How to Use the Filter Command in Excel 2007
Filtering data in Excel 2007 is not unlike sorting. However, rather than order data in a more convenient way, you can temporarily hide data so that you can speed up your work process. When you are done, you un-filter the data and continue working in your Excel 2007 spreadsheet normally.
Suppose you have an address list in an Excel 2007 spreadsheet and you want to see only the addresses of people who have the last name “Smith." To begin your filter, click on the column that contains the data you want to filter. Then, click on the DATA tab on the Excel 2007 Ribbon and click on the FILTER button (see Figure 1).
When you click on the FILTER button, an arrow appears at the top of the column that contains the data you want to filter (see Figure 2). Click the arrow and then click on the check mark next to the SELECT ALL option. This simply clears all of the checks next to each of the data points in that particular column. Now place a check mark next to the data points you want to filter. In this case, check the box next to the data labeled “Smith."
Click OK and notice that the spreadsheet now only displays data where the LAST NAME column contains the text “Smith." Notice also that the arrow next to the LAST NAME column shows a picture of a funnel and that there are now “missing" row numbers down the left side of the spreadsheet. These row numbers are now blue rather than the default black. This is to remind you that you are viewing filtered data, not all of the information contained in the spreadsheet.
To view all of the data in the spreadsheet again, click on the funnel icon at the top of the LAST NAME column and check SELECT ALL. Now you are seeing all of the data in the spreadsheet again.
To turn off the filtering permanently, click again on the FILTER command button on the DATA tab of the Excel 2007 Ribbon. Note that unless you click the FILTER button on the Ribbon after you are done filtering, Excel 2007 remains in filter mode. While in filter mode, you may not be able to use all of the functions in Excel. Some of the functions that would conflict with filtering are disabled. Therefore, be sure to click on the Filter command on the Ribbon when you are done filtering to make Excel fully functional again.