Key Skills > Filters Excel Filter Topics on ContexturesUse Excel AutoFilters and Advanced Filters to show specific data from a list or Excel table.
Tip: If you are looking for pivot table filter tips, go to the Excel Pivot Table Filters page. Author: Debra Dalgleish |
AutoFilter TutorialsThese 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. |
Advanced Filter Tutorials1 --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 VideosHere'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 FilesHere 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. |
![]() |
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 TopicsData Validation | Pivot Tables | Formulas | Macros | Format | Charts | Filters |
Last updated: September 7, 2023 12:02 PM