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.