how to clear all filters in excel table

Reset All Filters in Your Excel Table

By James Martinez
AD

Imagine you've applied multiple filters to an Excel table, and now you want to view the entire dataset again. Clearing all filters at once can be quite handy, saving you time and effort. Let's guide you through this simple yet crucial Excel maneuver.

Before we begin, it's essential to understand that Excel filters data based on the active cell range. So, before clearing all filters, ensure you have the desired range selected. Now, let's dive into the process.

Clearing All Filters from a Single Column

If you've applied filters to just one column, removing them is a breeze. Here's how:

AD
An Easy Guide to Filtering Data in Excel
An Easy Guide to Filtering Data in Excel
How to get non-adjacent columns with FILTER function in Excel
How to get non-adjacent columns with FILTER function in Excel
How to apply filter on Excel | MS Excel Data Filtering
How to apply filter on Excel | MS Excel Data Filtering

1. Select the data range (including headers) where you've applied filters. The column with the filter arrows should be within your selection.

Method 1: The Simple Way

2. Click on the 'Data' tab in the ribbon.

How to Filter Data in Excel Step by Step
How to Filter Data in Excel Step by Step
How to Use a Slicer to Filter a Table in Microsoft Excel
How to Use a Slicer to Filter a Table in Microsoft Excel

3. In the 'Sort & Filter' group, select 'Clear' and then 'Clear Filters from "Column1"'. Replace 'Column1' with the actual column name containing your filter.

Method 2: Using keyboard shortcut

2. Press 'Alt + O' (for Older Excel versions) or 'Ctrl' + 'Shift' + 'L' (for newer versions) to open the 'Sort & Filter' dialog box.

AD

3. Click 'Clear' and select 'Clear Filters from "Column1"' (replace 'Column1' with your column name).

Clearing All Filters from an Entire Table

When dealing with an entire table, clearance procedure might differ slightly. Here's how you can do it:

1. Select the table (including headers) by clicking on the table's name in the 'Properties' group of the 'Home' tab, or directly clicking on any cell within your table range.

AD

Method 1: Using Data tab

2. Go to the 'Data' tab and in the 'Sort & Filter' group, click on 'Clear'. Then select 'Clear Filters from "Table1"'. Replace 'Table1' with your actual table name.

Method 2: Using keyboard shortcuts

2. Press 'Alt + O' (for older versions) or 'Ctrl' + 'Shift' + 'L' (for newer versions).

3. In the 'Sort & Filter' dialog box, select 'Clear' and choose 'Clear Filters from "Table1"' (replace with your table name).

AD

Now that you've mastered clearing filters in Excel, you can effortlessly manage your data, unhiding those useful yet temporarily filtered insights. Happy data analysis!

AD