Excel shortcuts

How to Clear Filters in Excel: A Quick and Easy Shortcut

If you're like most people, you probably use filters in Excel all the time. Filters are a great way to quickly and easily view only the data that you want to see. But what happens when you want to clear the filter and view all of the data again?

If you're not sure how to clear filters in Excel, don't worry - it's actually very easy to do. In this article, we'll show you a quick and easy shortcut that you can use to clear filters in Excel with just a few clicks.

First, let's take a look at how to apply a filter in Excel. To do this, simply click the Filter button in the toolbar. Then, click the column that you want to filter and select the filter criteria that you want to use.

For example, let's say that you have a column of data that contains dates. If you want to only view the data for the month of January, you would click the column header, then click the Filter button and select the Month filter. Then, you would select January from the list of options.

Now that we know how to apply a filter, let's take a look at how to clear filters in Excel. To do this, simply click the Filter button again and then click the Clear Filter button.

That's all there is to it! This shortcut will instantly clear any filters that have been applied to the data. Now you can view all of the data in the worksheet again.

We hope this article has been helpful. If you have any questions, please feel free to post them in the comments section below.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.