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. Open your spreadsheet in Excel. You can do this by double-clicking the file on your computer.

Table of Contents

Clearing Filters in one Column
Clearing all Filters in a Worksheet

Method 1 of 2:

Clearing Filters in one Column

Open your spreadsheet in Excel. You can do this by double-clicking the file on your computer.
Go to the worksheet on which you want to clear the filters. Worksheet tabs are at the bottom of the current sheet.
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]
Click Clear Filter from (column name). The filter is now cleared from the column.

Method 2 of 2:

Clearing all Filters in a Worksheet

Open your spreadsheet in Excel. You can do this by double-clicking the file on your computer.
Go to the worksheet on which you want to clear the filters. Worksheet tabs are at the bottom of the current sheet.
Click the Data tab. It's at the top of the screen.
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.

You've just finished reading the article "How to Clear Filters in Excel" edited by the TipsMake team. You can save how-to-clear-filters-in-excel.pdf to your computer here to read later or print it out. We hope this article has provided you with many useful tech tips and tricks. You can search for similar articles on tips and guides. Thank you for reading and for following us regularly.

Isabella Humphrey

Update 05 March 2020

« PREV : How to Print Part of...

How to Calculate... : NEXT »