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.

Method 1 of 2:

Clearing Filters in one Column

How to Clear Filters in Excel Picture 1

Open your spreadsheet in Excel. You can do this by double-clicking the file on your computer.
How to Clear Filters in Excel Picture 2

Go to the worksheet on which you want to clear the filters. Worksheet tabs are at the bottom of the current sheet.
How to Clear Filters in Excel Picture 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]
How to Clear Filters in Excel Picture 4

Click Clear Filter from (column name). The filter is now cleared from the column.

Method 2 of 2:

Clearing all Filters in a Worksheet

How to Clear Filters in Excel Picture 5

Open your spreadsheet in Excel. You can do this by double-clicking the file on your computer.
How to Clear Filters in Excel Picture 6

Go to the worksheet on which you want to clear the filters. Worksheet tabs are at the bottom of the current sheet.
How to Clear Filters in Excel Picture 7

Click the Data tab. It's at the top of the screen.
How to Clear Filters in Excel Picture 8

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.