Microsoft Office Tutorials and References
In Depth Information
2. On the Home tab, in the Editing group, click Sort & Filter , and then click Filter .
A filter arrow appears in each column’s header cell.
3. Click the Date column filter arrow and then, from the menu that appears, clear the
March check box.
Excel removes the check from the March check box and changes the state of the
Select All and 2010 check boxes to indicate that some items within those categories
have been filtered.
4. Click OK .
Excel hides all rows that contain a date from the month of March.
5. Click the Center column filter arrow and then, from the menu that appears, clear
the Select All check box.
Excel clears all the check boxes in the list.
6. Select the Midwest check box, and then click OK .
Excel displays only those exceptions that occurred in the Midwest distribution
center during the month of April.