Sample Excel Files - Filters

Get these free Excel workbooks, to see how AutoFilters and Advanced Filters work.

For more Excel workbooks, go to the main Excel Sample Files page.

Before You Use a Sample File

After you download an Excel sample file, you might need to:

Unblock the file, so Excel lets you edit it
Allow macros to run, if the file contains any macros

The steps are explained in the sections below

Unblock Files

Before you unzip the Excel files, follow the steps below, to unblock the files. Otherwise, Windows security might block you from using the file.

In Windows Explorer, right-click on the zipped file
1. In the pop up menu, click Properties
2. Add a check mark in the Unblock box, near the bottom of the Properties window.
Click OK, to close the Properties window.

Allow Macros

Some files contain macros, so enable macros when you open the files, if you want to test the macros.

Open the Excel file
If a yellow Security Warning bar appears, click the Enable Content button, to allow macros to run

security bar enable content

Excel Files - Filters

Get these free Excel workbooks, to see how AutoFilters and Advanced Filters work.

Colour Filter Headings

Get the Excel File: FL0032 - Colour Filter Headings

Filter a column, and a macro colours the heading cell with bright yellow fill, so it's easy to spot. Clear the filter, and the macro restores the original cell colour. Instructions are in the workbook

filtered column has coloured heading cell

Filter Data in Multi-Select Cells

Get the Excel File: FL0031 - Filter Data in Multi-Select Cells

In the sample file, there are multiple weekday names in the WorkDays column. Click the weekday Slicer, to filter for rows that contain the selected weekday name. For instructions, go to the Drop Downs - Select Multiple Items page

click the Slicer to filter the WorkDays column

Filter Data to Multiple Sheets

Get the Excel File: FL0030 - Filter Data to Multiple Sheets

Click buttons to run macros that filters the original data to different sheets, based on criteria.

click button to send records to separate sheets

Colour Filter Headings in Excel Table

Get the Excel File: FL0029 - Colour Filter Headings

Filter a column, and the heading cell turns bright red. Clear the filter, to remove the red fill colour.

column heading has red fill colour when filter applied

Clear Filters One at a Time

Get the Excel File: FL0028 - clearnextfiltermacro.zip

After applying filters to an Excel Table, click the Clear Next Filter button to clear the filters one at a time, from right to left. Click the Reset button to set the Clear Next column number back to its original column count.

FL0028

Set Filter Criteria With Slicers

Get the Excel File: FL0027 - Set Filter Criteria With Slicers

Use Slicers to select criteria for an Advanced Filter. Then, click the Get Data button to run the macro for the Advanced Filter

use slicers to select advanced filter criteria

Save Filter Settings in Custom Views

Get the Excel File: FL0026 - customviewsnames.zip

To make it easier to reapply filters, you can save settings in a Custom View. Show the selected view's name on the main sheet, based on a list of view names.. Instructions: Save Excel Settings in Custom Views

FL0026

Slicers for Excel 2010 Tables

Get the Excel File: FL0025 - Filter Excel 2010 Table With Slicers

Slicers for Excel Tables were introduced in Excel 2013. If you're using Excel 2010, try this technique from AlexJ. Instructions are on my Contextures blog: Use Slicers to Filter a Table in Excel 2010

click slicers to filter columns in formatted Excel table

Shorten Data Validation List

Get the Excel File: FL0024 - Shorten Data Validation List

Shorten a Data Validation list by using Advanced Filter to extract a list of names that start with selected letter. Instructions are on my Contextures blog: Shorten a Data Validation List

Movies Database

Get the Excel File: FL0023 - Movies Database

This macro extracts a list of movies for the selected category or actor. There are details on my Contextures Blog: Movies database details.

Click to Filter & Colour

Get the Excel File: FL0022 - FilterClickColour.zip

Click on a cell to filter a column by the selected value. Click on a column heading to remove that column's filter. Heading cells on filtered columns are coloured.

Click to Filter

Get the Excel File: FL0021 - FilterClick.zip

Click on a cell in the filter range to filter that column by the selected value. Click on a column heading to remove that column's filter. Turn FilterClick feature off to perform other activities, such as sorting.

Fast Filter

Get the Excel File: FL0020 - Fastfilter.zip

Type criteria in the row above an AutoFilter, instead of selecting from the dropdown lists. The cells with criteria change colour, so you can easily see which columns have a filter applied, and the criteria. From Roger Govier.

Filter Latest Date for Customer

Get the Excel File: FL0019 - AdvFilterLatestDate.zip

Select a customer, and a macro runs an advanced filter to extract the latest sale record for that customer.

Highlight Filtered Headings in List

Get the Excel File: FL0018 - ilterHighlightList.zip

In an Excel List, a macro highlights column headings where filters are applied.

Filter All Columns

Get the Excel File: FL0017 - AdvFilterStateNum.zip

Enter a number on the worksheet, and the list filters to show only the records that contain that number in one of the five columns.

Move Items to Order Form

Get the Excel File: FL0016 - ProductsListOrder.zip

Select items from a filtered list, and event code moves the item to an order form.

Filtered Chart Title

Get the Excel File: FL0015 - FilterChartTitle.zip

Chart data and chart title change when an AutoFilter is applied to the source data.

Colour Filter Headings

Get the Excel File: FL0014 - FilterColour.zip

Event code colours the filtered column headings, when an AutoFilter is applied.

Create New Sheets from Filtered List

Get the Excel File: FL0013 - AdvFilterRepFiltered.zip

This macro uses Advanced Filter to create separate sheet of orders for each sales rep visible in a filtered list; macro automates the filter.

Map Based Filter

Get the Excel File: FL0012 - FilterMap.zip

This macro extracts regional data when you click a map shape.

Extract Random Records

Get the Excel File: FL0011 - ExtractRandom.zip

This macro extracts a random set of records from a database. Based on code from Ross Connell.

FL0010 - Summarize Budget Details

Get the Excel File: FL0010 - AdvFilterBudget.zip

This macro uses Advanced Filter to summarize budget details for selected month, or full year

Update Sheets from Master

Get the Excel File: FL0009 - AdvFilterCity.zip

This macro sends data from the main sheet to individual worksheets. It creates a list of unique items, creates a sheet for each item, then replaces old data with current.