Excel > Excel 2007 Intermediate > Sorting and Filtering

Autofilter

You can filter data to only display the rows that you want to see. All other data is hidden. You can also filter by multiple columns reducing your data each time to what you want.

Apply a filter

1. Select a cell in the range that you wish to filter
2. Click the Sort & Filter button in the Editing group of the Home tab
3. Select Filter

Filter buttons appear in the first cell of each column (these should be your headers)

4. Click the filter button for the column you want to filter

A list of options appear at the bottom of the menu

5. Check the boxes next to the values that you want to display, and uncheck the box for the values that you want to hide.
6. Click Ok

The list is filtered showing only the records requested



7. To apply a filter to another column, click the other columns filter button and check the appropriate boxes

Clear a filter

To restore the records as they were prior to filtering, you will need to clear the applied filters.

To clear a filter from one column:

1. Click the filter button for the column whose filter you wish to clear
2. Click the Clear Filter From option from the list

To clear the filters from all columns:

Click the Sort & Filter button in the Editing group of the Home tab

Select Clear

You can also clear the filters of all columns by clicking the clear button in the Sort & Filter group of the Data tab.

Removing the filter

Not that they are doing any harm, but you may wish to remove the filter buttons when you have finished with your filtering tasks.

1. Click the Sort & Filter button in the Editing group of the Home tab
2. Select Filter
3. The filter buttons disappear and any filters you may still have applied are removed

Sorting by colour or icon Custom Autofilter

Guides