Page 24 - Trackpad_V1_Book 7_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 Sort & Filter command.
2 Select Filter
option from the “Break habits such as sitting in wrong
postures which slow down your typing
drop-down menu.
speed and 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 the
desired fill effect.
22 Trackpad (Version 1.0)-VII

