Page 24 - Chinmaya_C7_flipbook
P. 24
CUSTOM FILTERS
Excel also allows you to use custom filters. For example,
you want to view the records where the House is To filter the data:
Ravi and the Gender is Girl. First, we will put a filter Short key Ctrl + +
in Column D and set the Gender to Girl by checking Shift L
against it, and then set the House to Ravi.
REMOVING FILTERS
To remove the filter, follow the given steps:
1 Click on the Sort
& Filter command.
Life Skills & Values
2 Select Filter “Break habits such as sitting in wrong
option from the postures slow down your typing speed and
drop-down menu. also lead to poor health.”
-Mr. Techie
CONDITIONAL FORMATTING
To apply conditional formatting to a series of data, follow the given steps:
1 Select the data and click on the
Conditional Formatting command.
2 Select the
desired option.
3 Choose
desired fill effect.
22 Premium Edition-VII

