Excel auto filter in Microsoft Excel 2003
Free Microsoft Office Tutorials
The Excel auto filter is a marvelous spreadsheet tool. In this lesson will be looking at auto filters in Microsoft Excel 2003. We will look at the basic auto filtering and also the custom filters that Microsoft provides .
Watch this short tutorial on how to use excel auto filter
How do you apply in Excel auto filter to a data set?
First click anywhere in your data set. Make sure that there are no blank rows and that your data set is surrounded by a blank column and row on all sides.
As you can see from the illustration: Click the Data menu tab then Filter then Auto filters. Auto filters will now be applied to the headers of your data.
To filter the data simply click the arrow in the column where you wish to filter and choose from the easy options. You will notice that the arrow will change colour to indicate to you that the auto filter is active in this column. You may then go on to add extra filters from other columns and the arrows will also then change colour to indicate that filters have been applied to those columns.
To remove the filter , click the arrow with the changed colour and then set to show "all".
Alternatively you could go to the Data tab then to the Filter tab then Show all and all of your data will be restored.
Custom Filters: Excel Auto filters on demand.
It is possible to apply a custom filter. As you can see from the illustration there are a range of options that can be applied. In this illustration we have filtered data in the column that contains postcodes. The data that has been filtered is greater than 2000 and less than 4000.
The Excel auto filter can filter large data sets very effectively. Sometimes Excel does it all so easily.
Let me know your comments.
Excel Auto Filter – Radar for the spreadsheet