Excel shortcuts

How to Remove All Filters in Excel with One Shortcut

If you're like most people, you probably use filters in Excel all the time to help you sort and analyze your data. But what if you want to remove all filters at once?

There's no built-in way to do this in Excel, but there is a shortcut you can use that will remove all filters from your worksheet in one go.

Here's how it works:

1. Select any cell in your worksheet.

2. Press the following keys at the same time: Ctrl + Shift + L

3. All filters in your worksheet will be removed.

That's all there is to it! This shortcut works in all versions of Excel. Give it a try the next time you need to remove all filters from your data.

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.