1. The shortcut key to toggle auto filter on and off is Shift+Ctr+L
2. Choose the command Data, AutoFilter
3. Choose the command Home, Format as Table, and pick a table - you
automatically get autofilters.
4. Choose the command Home, Sort & Filter, Filter
5. You can add all of these commands to the QAT.
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.