How to Clear Filters in Excel

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.

Isabella Humphrey

Update 05 March 2020

You should read it

May be interested

Instructions for using filters in Yahoo Mail
most people think that filtering in email programs is simply to prevent spam. not only that, the filter can also be used to help users manage very useful email messages.
Photoshop: Principles of using filters
photoshop uses filters to change image data in different ways. for example, instead of using the blur tool on most images, you can use one of the blur filters and change every pixel in v.
AND function in Excel
logical functions are used a lot in excel with results that return true, false. the and function is a very common logical function in excel, but for those of you who are new to excel, it may not be clear.
5 most popular iPhone camera filters
after testing all the photo filters on your iphone, you will finally choose your favorites. these are the best filters you should use for your photos.
Add a whitelist for Gmail
creating spam filters in gmail can sometimes lead to the risk of filtering out real friends' emails. gmail may accidentally mark a friend's email ...
How to Use Smartphone Filters to Fix Bad Lighting in Photos
while smartphone cameras are generally good at judging the brightness or darkness of a photo, they aren't perfect.
7 free Excel templates to help manage the budget
the focus of every financial plan lies in managing money or budget. whether you have a large amount of money on hand or just live on a monthly salary, you need a clear spending plan to know what your money will be used for.
How to create filters in Gmail to classify messages?
creating filters in gmail helps you sort and manage your mail more quickly, you should create filters suitable for each purpose of the mail. if you do not know how to create a filter in gmail, please follow the instructions in the article below.
How to use filter on Zoom, turn on the filter for Zoom
new zoom feature filters for the video screen to change the look of the online learning screen on zoom, along with many filters for our faces to use.
How to create a Snapchat filter
snapchat is still one of the most popular multimedia messaging apps on the planet. and now, you can even create your own snapchat filter.

How to Clear Filters in Excel

Clearing Filters in one Column

Clearing all Filters in a Worksheet

You should read it

May be interested

Office information