How to Clear Filters in Excel

This wikiHow teaches you how to remove data filters from a column or an entire worksheet in Microsoft Excel.

Method 1
Method 1 of 2:
Clearing Filters in one Column

  1. Image titled Clear Filters in Excel Step 1
    1
    Open your spreadsheet in Excel. You can do this by double-clicking the file on your computer.
  2. Image titled Clear Filters in Excel Step 2
    2
    Go to the worksheet on which you want to clear the filters. Worksheet tabs are at the bottom of the current sheet.
    Advertisement
  3. Image titled Clear Filters in Excel Step 3
    3
    Click the down-arrow next to the column-heading. In some versions of excel, you’ll see a tiny funnel icon next to the arrow.[1]
  4. Image titled Clear Filters in Excel Step 4
    4
    Click Clear Filter from (column name). The filter is now cleared from the column.
    Advertisement

Method 2
Method 2 of 2:
Clearing all Filters in a Worksheet

  1. Image titled Clear Filters in Excel Step 5
    1
    Open your spreadsheet in Excel. You can do this by double-clicking the file on your computer.
  2. Image titled Clear Filters in Excel Step 6
    2
    Go to the worksheet on which you want to clear the filters. Worksheet tabs are at the bottom of the current sheet.
  3. Image titled Clear Filters in Excel Step 7
    3
    Click the Data tab. It’s at the top of the screen.
  4. Image titled Clear Filters in Excel Step 8
    4
    Click Clear in the “Sort & Filter” section. It’s near the center of the toolbar at the top of the screen. All filters in the worksheet are now cleared.
    Advertisement

You Might Also Like

How to
Unhide Rows in Excel
Create a Mortgage Calculator With Microsoft Excel
How to
Create a Mortgage Calculator With Microsoft Excel
Change from Lowercase to Uppercase in Excel
How to
Change from Lowercase to Uppercase in Excel
Unprotect an Excel Sheet
How to
Unprotect an Excel Sheet
Make a Spreadsheet in Excel
How to
Make a Spreadsheet in Excel
Create a Graph in Excel
How to
Create a Graph in Excel
Open a Password Protected Excel File
How to
Open a Password Protected Excel File
Convert Notepad to Excel
How to
Convert Notepad to Excel
Download Microsoft Excel
How to
Download Microsoft Excel
Link Sheets in Excel
How to
Link Sheets in Excel
Create a Drop Down List in Excel
How to
Create a Drop Down List in Excel
Add Links in Excel
How to
Add Links in Excel
Convert Excel to Word
How to
Convert Excel to Word
Run a Multiple Regression in Excel
How to
Run a Multiple Regression in Excel
Advertisement

References

  1. ↑ https://support.office.com/en-us/article/Remove-a-filter-f147ac85-4fd6-4143-b52d-ce153250fed3

About This Article

Nicole Levine, MFA
Written by:
Nicole Levine, MFA
Tech Specialist
This article was written by Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for wikiHow. She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies. Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions. This article has been viewed 86,247 times.
How helpful is this?
Co-authors: 1
Updated: March 29, 2019
Views: 86,247
Categories: Microsoft Excel
Advertisement