Applying a Custom AutoFilter: MS Excel

Custom AutoFilters can be created to meet specific needs. A custom AutoFilter could be used to display records that contain either one value or another. A custom AutoFilter could also be used to display records that meet more than one condition for a column, such as records that contain values within a specific range, such a values between 50 and 1,000.

Follow the easy steps below to apply a Custom AutoFilter:

1. Position the active cell anywhere within the data list or within the header row.
    
2. Choose Data | Filter | AutoFilter.
    
3. Drop-down arrows appear along the top row of the list.
    
4. Click on the drop-down arrow of the field to filter.
    
5. Choose Custom.
    
6. The Custom AutoFilter dialog box appears.
    
7. The custom AutoFilter dialog box is used to create criteria for only one field at a time.
    
8. Select the desired options.
    
9. Choose OK.

That's a lot easier that you thought is was going to be isn't it?

Next, I will show you how to use the Subtotal function with AutoFilter.

When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!