How to Filter in Excel 2007

By Jason Artman

If you frequently use Microsoft Excel 2007, you might find yourself regularly looking at spreadsheets that contain a great deal of repeated information. Excel 2007 has the ability to work with that repeated information so that you can look at only those rows in a spreadsheet that contain--or do not contain--the information you choose. For example, this feature can be used to show only expected payments from a single company on a large accounts payable worksheet. Use the filter function in Excel 2007 to show only specific information in a large worksheet.

Step 1

Open the worksheet that you want to filter data from. Click the square button with a triangle inside it, in the upper-left corner of the worksheet between the "A" and "1" cells. The entire spreadsheet is now highlighted.

Step 2

Click the "Data" tab at the top of the screen, then click the "Filter" button. Each column in the worksheet now has a drop-down menu indicated by a button with a down-facing arrow.

Step 3

Click the button at the top of the column that you want to filter data from. A drop-down menu appears containing all of the different values contained within the column. Each value has a box with a check mark in it.

Step 4

Remove the check from next to each value that you do not want to be displayed. When this feature is used, rows containing the data that you filtered out will be hidden. Alternatively, click "Select All" to remove the check from next to every value, then place a check in the box next to each value that you want to be displayed.

Step 5

Click "OK." The filter takes effect immediately. Every row containing the value that you removed the check from is hidden. To resume viewing the entire worksheet, click the "Filter" button at the top of the screen.