Insert filter selects into the document (MS Excel)

2008-08-18

Inserting filter select fields in excel is very simple but I always forget it… :)
Let`s take some simple data for example:

Microfot Excel 2007

Microfot Excel 2007


Now select header row:
Microfot Excel 2007

Microfot Excel 2007


In “Home” pane press “Sort & Filter” and select Filter:
Microsoft Excel Filter tips

Microsoft Excel Filter tips


That’s all! Now you can filter rows by contents:
Microsoft Excel Filter tips

Microsoft Excel Filter tips


MicrosoftExcel filter tips

MicrosoftExcel filter tips