AutoFilter

Tips, Tricks, and Answers

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

Counting Unique Names
When you've got a column full of names, you may want to get a count of how many of those names are unique. You can make quick work of this task using the techniques described in this tip.

Creating Your Own AutoFilter Tool
Want a tool that will help you toggle AutoFilter on and off? Excel provides some tools you can use, but you need to be careful that you choose the right ones.

Defining a Custom AutoFilter
The filtering capabilities of Excel are very helpful when you are working with large sets of data. You can create a custom AutoFilter that will display only the information you want to see.

Deleting Every X Rows in a Worksheet
Do you need to delete every third, fourth, or seventh row in a worksheet? There's an easy way to do it without even resorting to macros—just use the technique described in this tip.

Using AutoFilters
Excel's AutoFilter tool is a great way to make a long list of items much more manageable. This tip explains how to set up an AutoFilter and display just the information you need.