Excel shortcuts

Shortcut to Clear Filters in Excel

If you're like most people, you probably use filters in Excel to help you sort and analyze your data. Filters can be a great way to focus on the data that you need, but they can also be a pain to remove when you're done with them. Luckily, there's a shortcut that you can use to quickly clear all filters from your data.

To use this shortcut, simply select any cell in your data range, then press the following keys:

Ctrl+Shift+L

This shortcut will instantly remove all filters from your data, and you'll be able to see all of your data again. If you need to apply filters again, you can always use the Ctrl+Shift+F shortcut to quickly apply filters.

So next time you're struggling to remove filters from your data, remember this shortcut and you'll be able to quickly get rid of them and move on with your work.

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.