Excel shortcuts

How to Add a Filter Shortcut in Excel

If you work with data in Excel, you know how important it is to be able to quickly filter that data to find the information you need. Excel makes it easy to filter data, but if you have to do it often, it can be a bit of a hassle to constantly go to the Data tab and click the Filter button. Luckily, there's a way to create a shortcut for filtering data in Excel so that you can do it with just a few clicks.

Here's how to add a filter shortcut in Excel:

  1. Open the workbook that contains the data you want to filter.
  2. Click the cell in the top-left corner of the data range (this should be the cell that contains the column headers).
  3. On the Home tab, in the Editing group, click the Sort & Filter button.
  4. Click the Filter button.
  5. Click the Shortcut button.
  6. In the Customize Quick Access Toolbar dialog box, click the Commands Not in the Ribbon option.
  7. In the list of commands, click Filter.
  8. Click the Add button.
  9. Click the OK button.
  10. In the Customize Quick Access Toolbar dialog box, click the OK button.
  11. You should now see the Filter button in the Quick Access Toolbar. You can click this button to filter your data with just a few clicks.

Now that you know how to add a filter shortcut in Excel, you can save yourself some time and effort the next time you need to filter your data. Give it a try and see how much easier it is to filter data with a shortcut.

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.