Page 25 - TrackpadV2.1_Class8
P. 25
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.
21 st
Century #Flexibility
Skills
2 Select Filter “Break habits such as sitting in wrong
option from the postures slow down your typing speed and
drop-down list. also lead to poor health.”
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.
Advanced Features of Excel 23

