In this topic you will learn how to use Auto Filter.
You can use AutoFilter to hide or sort the data in your worksheet.
In this example you will filter the data so only employees whose birth year is 1993 will display.
Click the Filter option.
Notice the each column displays a drop-down button.
Click the checkbox to the left of the Select All option to deselect it.
A list of employees who were born in 1993 displays. The filter symbol displays next to the column header to denote that filtering has occurred.
This completes Auto Filter.