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
- 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.
4 ★ | 2 Vote
You should read it
- 4 types of professional filters should be available when taking photos
- What is a worksheet? Differentiate between Worksheet and Workbook
- MS Excel 2007 - Lesson 5: Edit Worksheet
- The Filter in AngularJS
- The 12 best Instagram filters for your photos
- How to use screen color filters in Windows 11
- Roll the list of the best family water filters on the market today
- Steps to lock columns in Excel
- How to rename, copy and move spreadsheets in Excel
- How to turn on Color Filters on Mac to improve the reading experience
- Instructions for using filters in Yahoo Mail
- Photoshop: Principles of using filters