How to Remove Filters in Microsoft Excel: 8 Steps

Table of contents:

How to Remove Filters in Microsoft Excel: 8 Steps
How to Remove Filters in Microsoft Excel: 8 Steps

Video: How to Remove Filters in Microsoft Excel: 8 Steps

Video: How to Remove Filters in Microsoft Excel: 8 Steps
Video: Math Antics - Circles, What Is PI? 2024, November
Anonim

This article teaches you how to remove data filters from a column or an entire Microsoft Excel worksheet.

Step

Method 1 of 2: Removing Filters in One Column

Clear Filters in Excel Step 1
Clear Filters in Excel Step 1

Step 1. Open the spreadsheet in Excel

Double-click the file name on your computer.

Clear Filters in Excel Step 2
Clear Filters in Excel Step 2

Step 2. Go to the worksheet whose filter you want to remove

The worksheet tabs are at the bottom of the currently displayed sheet.

Clear Filters in Excel Step 3
Clear Filters in Excel Step 3

Step 3. Click the down arrow at the head of the column

In some versions of Excel, you'll see a small funnel symbol next to the arrow.

Clear Filters in Excel Step 4
Clear Filters in Excel Step 4

Step 4. Click Remove Filter From “Column Names” or Clear filter from “Column Name”.

The filter will be removed from that column.

Method 2 of 2: Removing Filters Across the Worksheet

Clear Filters in Excel Step 5
Clear Filters in Excel Step 5

Step 1. Open the spreadsheet in Excel

Double-click the file name on the computer.

Clear Filters in Excel Step 6
Clear Filters in Excel Step 6

Step 2. Go to the worksheet whose filter you want to remove

The worksheet tabs are at the bottom of the currently displayed sheet.

Clear Filters in Excel Step 7
Clear Filters in Excel Step 7

Step 3. Click the Data tab

It's at the top of the screen.

Clear Filters in Excel Step 8
Clear Filters in Excel Step 8

Step 4. Click Clean or Clear in the “Sort & Filter” or “Sort & Filter” section.

This menu is in the middle of the toolbar at the top of the screen. All filters in the worksheet will be cleared.

Recommended: