(17) How to apply filter in Microsoft Excel.
When a filter is added to the header row of spreadsheet, a drop-down menu appears in each of the cell of the header row. This provides you with a number of filter option than can be used to specify which rows of the spreadsheet are to be displayed.
To apply excel filter/ autofilter:
(i) First select the header of the column cell. From Data tab click to Filter.

Now you can filter data by click drop-down icon as per your requirement. Example: I want to see Section-3 result only. Just need to click drop-down icon of Section Name. Than need to click Section-3. The result will be like below picture.

Video:
How to use Filter in Microsoft Excel:
|