Key Skills > Filters > AutoFilters Excel AutoFilter BasicsUse an Excel AutoFilter to hide some of the data in your worksheet. For example, you can focus on sales to a specific customer, or print a list of your largest orders |
Create an Excel Table1. Set up the Excel TableIn Excel 2007, and later versions, you should create an Excel Table from your data, and use its built in filtering features. If you are using an Excel Table, you can skip to the next section, Filter One Column. Note: For Excel 2003 AutoFilter instructions, please go to Excel 2003 AutoFilter Basics If your data is not in an Excel Table, follow these steps to prepare your list for an AutoFilter.
2. Turn on FilteringIn Excel 2007 and later, if you're using an Excel Table, it has built-in filtering features. If your data is not in an Excel Table, follow these steps to add an AutoFilter.
A dropdown arrow appears at the right side of each column heading. |
Clear an AutoFilterAfter you have applied one or more filters, you can:
To save time, you can
Clear a Specific Filter
|
Filter for Date Range ColourYou can filter a list of dates for a date range, by using the Between date filter, as shown in the next section. With that method, you'll have to type the dates in the filter settings, each time you want to use a different date range. This video shows how to add Conditional Formatting to the date cells, so the font colour changes slightly, based on the start and end dates entered on the worksheet. Then, you can use the Filter by Color option, to show only the dates in the specified range. This technique is the second method shown in this video, starting at the 2:00 mark Filter for a Specific Date RangeIf a column contains dates, you can filter to find a specific date
or date range, or a dynamic date range. In this example, you'll filter
for the orders received in January 2011.
|
Get a Sample FileBasic AutoFilter: Click here to download a zipped workbook with the basic examples for Excel AutoFilter techniques. . The zipped file is in xlsx format, and does not contain macros Date Range: Download the sample file for the AutoFilter for Date Range example. The zipped file is in xlsx format, and does not contain macros More AutoFilter Tutorials |
Last updated: October 20, 2023 3:12 PM