Using the Excel2003 AutoFilter tool to filter your data skillfully

using the Excel2003 AutoFilter tool to filter your data skillfully

Method One, directly select the Filter object

1. Open the Excel table and select the data-filter-AutoFilter command in the menu bar. Here we take the example of "sex woman".

2. The Inverted triangle button appears in the lower-right corner of the first row of cells. Click the category you want to filter, and select the filtered object.

Method Two, select the Filter object by "Custom".

1. We select the cell named "Sex", click the Drop-down triangle button in the lower right corner of the cell, and select "Customize" in the pop-up Drop-down box.

2. Pop the Custom AutoFilter dialog box, select "include" in the bar below "sex", select "Female" in the bar on the right, or enter "female" yourself, and then click OK to complete the filter.