Key Skills > Filters

Excel Filter Topics on Contextures

Use Excel AutoFilters and Advanced Filters to show specific data from a list or Excel table.

  • AutoFilters are built into named Excel tables, and they are easy to use.
  • Advanced Filters are accessed through a command on the Ribbon's Data tab. It's harder to set up an Advanced Filter, but you can use complex criteria, above the limits of an AutoFilter.

Tip: If you are looking for pivot table filter tips, go to the Excel Pivot Table Filters page.

Author: Debra Dalgleish

AutoFilter Tutorials

These tutorials show how to use Excel AutoFlters, manually, or with macros.

1 -- Excel Filters: AutoFilter Basics -- Use Excel's AutoFilter feature to show or hide specific data in a list, to focus on a product or customer, or print selected data

2 -- Excel AutoFilter Tips -- Tips for Excel's AutoFilter - see count of filtered records in status bar, not all items showing in filter drop down, filter text in a long string

3 -- Excel Filters AutoFilter Macros -- Control Excel's AutoFilter feature with macros to show all records, hide filter arrows, copy filtered rows and count visible rows.

4 -- Use These Excel Macros to AutoFilter Lists -- Excel AutoFilter macros for lists. Use these macros to show all records, hide filter arrows, copy filtered rows and count visible rows.

autofilter customer

Advanced Filter Tutorials

1 --These tutorials show how to use Excel Advanced Flters, manually, or with macros.

Excel Advanced Filter Intro - Easy Steps, Videos, Examples -- How to use Advanced Filter in Excel with criteria, send data to different sheet, or filter in place. Short videos, easy examples, written steps, workbook

2 --How to Set Up Excel Advanced Filter Criteria - Examples -- Excel advanced filter examples take you beyond basic steps. See how to filter top records, blank cells, and more. Written steps, videos, Excel workbook

3 --Excel Advanced Filter Macro Examples Send Data to New Sheet -- Advanced filter macros send data to different sheet or file, one for each person in list. How to record, edit macros. Video, written steps, Excel file

4 --How to Use Slicers With Excel Advanced Filter -- Use Excel Slicers to select criteria, show matching records from list. View specific data, keep original records safe on hidden worksheet

Excel Filter Videos

Here's one of my latest Excel filter videos, and almost all of my Excel filter tutorial pages include a video too.

With an advanced filter, you can extract data to a different sheet. Watch this video to see the steps, and the written instructions are on the Advanced Filter Intro page.

Excel Filters - Sample Files

Here are the download links for a couple of my latest Excel Filter sample workbooks, and most of the Excel tutorial pages include a sample file too.

More Workbooks: For even more filter sample files, go to the Excel Sample Files page, and scroll down to the Filters section.


Colour Filter Headings -- Code runs automatically when you filter one of the columns, and colours heading cell with bright yellow fill, in the filtered column.
Excel File: Colour Filter Headings (has macros)

FN0063 Filter Data in Multi-Select Cells-- Above the table, click on a Slicer, to filter the WorkDays column for any rows that contain the selected weekday name 
Excel File:
Filter Data in Multi-Select Cells (has macros)

More Excel Topics

Data Validation | Pivot Tables | Formulas | Macros | Format | Charts | Filters


Last updated: September 7, 2023 12:02 PM