How to Filter Data in Microsoft Excel 2007

1.
Select the Home Tab on the Ribbon. The Ribbon is the group of icons and tools located directly above the work area.
2.
Locate the Editing Group on the far right side of the Home Tab. Click on the 'Sort and Filter' button to reveal a drop-down menu of options. Click on 'Filter'.
3.
Click on the drop-down arrow that Excel added next to the field you would like the data filtered by. Select the choice you would like to see filtered.
4.
Click on another drop-down menu if you would like to filter the remaining data by an additional criteria.
5.
Click on the filter icon next to the field header used to filter the data to remove the filter and return the list to its original state.