Description: This article describes how to filter data in Microsoft Excel 2010.

1. To filter data in an Excel 2010 spreadsheet, first click on the Data tab.

2. Click on the cell title of the column that is to be filtered (in this case Name) and then click the Filter button.

3. A dropdown arrow will appear at the far right edge of each sortable column title.

4. Click the arrow of the column to be sorted (in this case, Age) and a drop down box will appear. Uncheck Select All.

5. All available filter options should be in the check mark list. Check the box (or boxes) that the data is to be filtered by. In this case, it will be filtered by age 24. Click the OK button below that.

6. Now only the Names whose age is 24 will be shown.

7. To unfilter the data, click the dropdown button in the title again. When the box appears, Select All will have a black box next to it, as some of the items are checked and some are not.

8. Click on the Select All box to re-select everything. Click OK. All data will be visible again.