Page 26 - trackpad v5.1 class 7 flipbook
P. 26
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
2 Select Filter Skills
option from the “Break habits such as sitting in wrong
drop-down menu postures slow down your typing speed and
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.
24 Pro (V5.1)-VII

