TECH

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?

MS Toggle  

 

 

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.