Learn How to Toggle Autofilter With Shortcut in Microsoft Excel

Toggle Autofilter With Shortcut in Microsoft Excel

Here we will show you how to toggle autofilter in Microsoft Excel. Like many other programs Microsoft Excel also uses similar key combinations while using shortcuts.

You can use the key combinations given below to toggle autofilter using the shortcut. This shortcut toggles filters on and off for a range of data. It works on tables or filtered lists, and it is the fast way to clear filters, you just turn autofilter off, then on again to reset all filters. It should be noted that in Microsoft Excel 2016 this shortcut doesn't work. So, here we go:

How to Toggle Autofilter With Shortcut in Microsoft Excel?

This shortcut toggles filters on and off for a range of data. It works on tables or filtered lists, and it is the fast way to clear filters, you just turn autofilter off, then on again to reset all filters. It should be noted that in Microsoft Excel 2016 this shortcut doesn't work. This way you can easily toggle autofilter using the shortcut.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel