5) Filtering data

Filtering data

In addition to sorting, you may find that adding a filter allows you to better analyze your data. To focus on a specific set of your data, you can filter a range of cells. When data is filtered, only rows that meet the filter criteria will display, and other rows will be hidden. With data filtered, you can then copy, format, print, etc., your data, without having to sort or move it first. To use a filter,

• Select the heading where filter has to be applied

 

• Select Data→AutoFilter from the menu bar 

• You will notice that all of your column headings now have an arrow next to the heading name.

 

• Click on the arrow next to the heading by which you want to filter, and you will see a list of all the unique values in that column. Check the box next to the criteria you wish to match and click OK. Click on the arrow next to another heading to further filter the data.

For example if you want to filter only female students, then click on the arrow next to gender and select only gender from the list (unmark all other options). This will display only the data whose gender is female.

 

When any data is filtered, the colour of the arrow changes and the small mark is seen below the arrow.

• If you want to clear the filter and see the complete data, then choose any one of the following options:

Option 1- Click on the respective filter and mark against ‘all’ and then click OK

 

Option 2 - Select the column in which you want to clear filter. Then select Data→More Filters →Reset Filter from the menu bar