About this tutorial:
Video duration: 1:57
There is an easy way to use keyboard shortcuts to toggle the excel filters
One of the handy features of Excel is AutoFilter. It allows you to quickly filter any list by the contents of a particular column. You can use the Customize option from the Tools menu to add an AutoFilter tool to your toolbars. This tool uses an image of a funnel and an equal sign.
The tool is a bit deceptive, however; it is not the same as the AutoFilter option available from the Data menu. The menu option is a toggle condition. If you have a cell selected in a list and you choose the menu option, then the…