Auto Filter

In this topic you will learn how to use Auto Filter.

Steps:

1. 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.

   Step 1

2. Click the Sort & Filter button.

   Step 2

3. Click the Filter option.

   Step 3

4. Notice the each column displays a drop-down button.

    

   Click the button to the right of the birth date field.

   Step 4

5. Click the checkbox to the left of the Select All option to deselect it.

   Step 5

6. Click the 1993 option.

   Step 6

7. Click the OK button.

   Step 7

8. 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.

   Step 8

This completes Auto Filter.

Table of Contents  Start Topic