2 Simple Ways to Clear Filters in Microsoft Excel

Easy ways to delete Excel filters using the menu or a keyboard shortcut

|

Do you need to remove data filters in an Excel worksheet? Filters can be cleared from an entire worksheet or a single column. Here's how.

Things You Should Know

To remove all filters in an Excel worksheet, click the "Data" tab. In the "Sort & Filter" section, click "Clear."
You can also use the keyboard shortcut: Alt + D + F + F.
To clear filters in one column, click the down-arrow next to the column heading. Click "Clear Filter from "(column name)."

Method 1

Method 1 of 2:

1
Open a workbook in Microsoft Excel. You can use an existing project or create a new spreadsheet. Make sure you're on the correct worksheet.
- Microsoft Excel is available on Windows and Mac. You can also use the online web version at https://www.office.com/.
This is the tab in the top toolbar, between Formulas and Review.
Advertisement
3
In the "Sort & Filter" section, click Clear. This will be next to a filter icon with an x. You can find this in the section between Queries & Connection and Data Tools.
- All filters in the worksheet are now cleared.
- If this option is greyed out, the workbook may be protected from edits. In this case, you'll need to unprotect it.

Method 2

Method 2 of 2:

1
Open a workbook in Microsoft Excel. You can use an existing project or create a new spreadsheet. Make sure you're on the correct worksheet.
- If you add a filter to a certain column, such as a specific color, you can remove it without affecting the other filters in the worksheet.
In some versions of Excel, you’ll see a tiny funnel icon next to the arrow.^{[1]XTrustworthy SourceMicrosoft SupportTechnical support and product information from Microsoft.Go to source}
3
Click Clear Filter from "(column name)". The filter is now cleared from the column.
- If needed, you can even combine two columns into one.