Excel shortcuts

The Best Excel Shortcut for Adding a Filter

If you're like most Excel users, you probably use filters all the time. Filters are a great way to quickly narrow down your data to only the rows that you want to see. But adding filters can be a bit of a hassle, especially if you have a lot of data. Fortunately, there's a great shortcut that you can use to quickly add filters to your data.

To use this shortcut, first select the data that you want to filter. Then, press the Alt + F1 keys on your keyboard. This will open the Insert Slicer dialog box. In the dialog box, select the field that you want to filter on and then click OK. That's it! Your data will now be filtered on the field that you selected.

This shortcut is a great time-saver if you use filters frequently. Give it a try the next time you need to add a filter to 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.