Applying a Custom AutoFilter: MS Excel
- by Carol Bratt on 20070328 @ 02:13PM EST | google it | send to friends
- Filed under Carol's Corner Office | (related terms: custom, display records, meet, filter, row)
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:
- Position the active cell anywhere within the data list or within the header row.
- Choose Data | Filter | AutoFilter.
- Drop-down arrows appear along the top row of the list.
- Click on the drop-down arrow of the field to filter.
- Choose Custom.
- The Custom AutoFilter dialog box appears.
- The custom AutoFilter dialog box is used to create criteria for only one field at a time.
- Select the desired options.
- 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!
Infopackets Game of the Week: Lottso!
Click any thumbnail to view a full screen sample.
[ Download (Free Trial) ~ 16.52 MB | Read Game Details ]
