Excel shortcuts

The Best Shortcut to Clear All Filters in Excel

If you're like most people, you probably use filters in Excel all the time. Filters are a great way to quickly narrow down your data to only the information you need. But what if you need to clear all the filters at once?

There are a few different ways to do this, but the best shortcut is to simply press the Ctrl + Shift + L keys at the same time. This shortcut will instantly clear all filters from your data, no matter how many there are.

If you're not a fan of shortcuts, you can also clear all filters by going to the Data tab and clicking the Clear button in the Sort & Filter group. Or, you can select all the cells in your data range and then press the Esc key on your keyboard.

Whichever method you choose, clearing all filters is a quick and easy way to get your data back to its original state. So next time you need to start fresh, remember the Ctrl + Shift + L shortcut and you'll be good to go!

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.