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

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

Clearing all Filters in a Worksheet

  1. Picture 5 of How to Clear Filters in Excel
    Open your spreadsheet in Excel. You can do this by double-clicking the file on your computer.
  2. Picture 6 of How to Clear Filters in Excel
    Go to the worksheet on which you want to clear the filters. Worksheet tabs are at the bottom of the current sheet.
  3. Picture 7 of How to Clear Filters in Excel
    Click the Data tab. It's at the top of the screen.
  4. Picture 8 of How to Clear Filters in Excel
    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.
Update 05 March 2020
worksheetfiltersclearcolumn

You should read it

Maybe you are interested

Category

System

Mac OS X

Hardware

Game

Tech info

Technology

Science

Life

Application

Electric

Program

Mobile