Eastern Michigan University

Filtering Data in Excel

To filter in Excel 2007, follow these steps:

Select All cells in the spreadsheet by clicking in the upper left-hand corner of the Excel screen.

Filter

Click the Format pull-down menu and select AutoFit Column Width from the list. This will set each column width wide enough to view the content in the field.

Filter

Click the Sort & Filter pull-down menu and select Filter from the list.

Filter

This will add a pull-down menu to each column header. The menu will show all the values listed in the column. By default all values are checked, or selected. To filter data follow these steps:

Filtering data in Excel

Click on the pull-down menu at the top of one of the columns. A Filtering menu will appear.

Uncheck all values by clicking Select All.

Filtering data in Excel

Click the radio button next to the value you want to filter on.

Click the OK button.

Filtering data in Excel

Once you have activated a filter, in the lower-left corner you will see the number of records your filter is displaying, out of the total number. (i.e. 58 of 395 records found) Filtering data in Excel

  • You can use more than one filter at a time. Remember, the second filter will only affect the subset of data created by the first filter.
  • You can remove a filter by clicking Clear Filter from the pull-down menu. Filtering data in Excel
Division of Information Technology

118 Pray Harrold

Ypsilanti, MI 48197

Phone: 734.487.3141

Fax: 734.481.9290