Excel shortcuts

The Best 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. But what happens when you need to clear those filters?

The good news is that there's a shortcut that can help you clear filters quickly and easily. Here's a step-by-step guide to using the shortcut:

  1. First, select the data that you want to filter. You can do this by clicking on the cell in the upper-left corner of the data range and then dragging your mouse down to the bottom-right corner.
  2. Next, press the Ctrl + Shift + L keys on your keyboard. This shortcut will instantly clear any filters that have been applied to your data.
  3. Finally, if you want to reapply your filters, simply press the Ctrl + Shift + A keys. This shortcut will apply your filters again.

That's all there is to it! Using these shortcuts can save you a lot of time when you need to clear or reapply filters in Excel.

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.