Page 56 - ModularV1.1 _c6_flipbook
P. 56
You will notice that the rows of unchecked data are removed from the list. You need not worry
as the data is not lost. Notice the row headings. Some of the row headings are missing. The
unchecked rows have just been hidden from the display. To get the data back, open the filter list
again and check the unchecked entries.
Suppose, you want to know the names of the students who have scored
more than 80 marks. Follow these steps to get the required information:
Step 1 Apply filters to the data.
Step 2 Click on the Marks Obtained column header to open the filter
drop-down list.
Step 3 Place your mouse over the Number Filters option to open a
sub-menu. Select the Greater Than option to open the Custom
AutoFilter dialog box.
Using Filter options
Step 4 Enter 80 in the criteria box and click on the OK button.
Notice that only the details of the students who have obtained marks greater than 80 are
displayed and the remaining rows get hidden.
Remove Filters Clickipedia
The filters once applied can be easily removed. Click
anywhere in the worksheet and repeat steps to apply The filter can also be applied through
filters. You will notice that the filter arrows in front of Sort & Filter group under the Data tab
the column headers disappear and the hidden rows by selecting the Filter command .
also reappear.
CONDITIONAL FORMATTING
Suppose you do not want to hide any rows but still want to highlight all the cells that satisfy
a condition, for example greater than 80. This type of formatting is known as Conditional
Formatting in Excel. To apply conditional formatting to a series of data, follow these steps:
Step 1 Select the data to which formatting is to be applied.
Step 2 Click on the Conditional Formatting command from the Styles group under the Home
tab to open a drop-down list. This list shows various criteria such as:
Highlight Cells Rules – This option is selected when you want to highlight all cells
satisfying a given condition. When you hover the mouse over this option, it opens a
sub-list showing criteria like Greater Than, Less Than, Equal To, Between, etc.
Top/Bottom Rules – This option is selected when you want to highlight some top or
bottom number of items in a data series. When you hover the mouse over this option,
it opens a sub-list showing criteria like Top 10 Items, Top 10%, Bottom 10 Items,
Bottom 10%, etc.
Data Bars – This option is selected when you want to add data bars to the cells having
numeric data. When you hover the mouse over this option, it opens a sub-list showing
bars of different types and colours that can be added to the cells.
54 Modular (Ver. 1.1)-VII

