Download Article
Easy ways to delete Excel filters using the menu or a keyboard shortcut
Download Article
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)."
Steps
-
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/ .
-
Click Data . This is the tab in the top toolbar, between Formulas and Review .Advertisement
-
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 .
Advertisement
-
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.
-
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] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
-
Click Clear Filter from "(column name)" . The filter is now cleared from the column.
- If needed, you can even combine two columns into one.
Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
Video
Tips
Submit a Tip
All tip submissions are carefully reviewed before being published
Name
Please provide your name and last initial
Thanks for submitting a tip for review!
References
About This Article
Thanks to all authors for creating a page that has been read 154,619 times.
Advertisement
