Worksheet: How to Clear Filters in Excel

This updated guide examines Worksheet: How to Clear Filters in Excel and organizes the essential facts, background, and practical takeaways in clear American English.

Method 1

Clearing Filters in one Column

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

Method 2

Clearing all Filters in a Worksheet

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