Topic: AutoFilter

The following articles are available. Click the article's title (shown in bold) to see the associated article.

Changing AutoFilter Drop-Down Arrow Colors When you use the AutoFilter capabilities of Excel (Data | Filter | AutoFilter), small drop-down arrows appear at the top of each column in your data table. The color of the drop-down arrows changes from black to navy blue if a filter is applied to the column. The color of the arrows cannot be changed, but there are workarounds that can be used to make filtered columns stand out better. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Filtering to a Date Range in the Past If you have a large number of data records, each with an associated date, you might want to filter that data so you see only the records from within the past month or so. You can do this easily by using the technique described in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Increasing the AutoFilter Drop-Down Limit When you turn on AutoFiltering, Excel displays a drop-down list at the top of each column in your data table. This list contains the unique values within each column. This tip describes the 1000-entry limit imposed on the list by Excel and how you can work around it. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Limits to Filtering Excel limits the number of items that can be shown in an AutoFilter drop-down list. Granted, it is a high limit, but it is a limit nonetheless. This tip explains the limit and provides some ideas about how you can better use filtering to find the data you need. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Macro Fails after AutoFilter When developing a macro that others may use, you might want to test it out to make sure it works properly if an AutoFilter is in effect. If it doesn’t, you can turn off the AutoFilter with a simple single-line command. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

More Than Two Conditions for Custom AutoFiltering Using the AutoFilter feature of Excel, you can define a custom filter that controls what information you see from a data table. Custom AutoFilters allow you to specify one or two criteria to be applied in the filtering process. This tip describes ways you can actually use more than two criteria. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Quickly Identifying Applied AutoFilters The AutoFilters feature is really handy when you want to work with a portion of a large dataset. After a while it is easy to forget which columns have filters applied and what those filters are. If you find yourself in this predicament, you’ll appreciate the techniques in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Setting Up Custom AutoFiltering The AutoFiltering capabilities of Excel provide quick and easy ways to view only portions of your available data. Beside the standard AutoFilter methods, you can create a custom AutoFilter that displays only the data that matches the criteria you define. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Suppressing Zero Values in PivotTables PivotTables are great for digesting and analyzing huge amounts of data. But what if you want part of that data excluded, such as information that has a zero value? Here’s a couple of quick ideas. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Turning Off AutoFiltering AutoFiltering is a huge help in analyzing moderate to large amounts of data in a table. Once you apply AutoFiltering, at some point you may want to turn it off. This tip explains how you can do that. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Using AutoFiltering When working with large collections of data, it is often necessary to choose subsets of that data. One easy way to limit the data visible is to apply filtering with Excel’s AutoFilter tool. This tip describes how to turn on AutoFiltering and use it to see exactly what you want to see. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Tips, Tricks, and Answers

Macros Rock!

Helpful Links

Great Info!

RSS Feeds