Keyboard shortcut for Auto-filter

W

Wombat

Hi!

Anyone know a trick to switch auto filter on and off without going through
the menu such as a keyboard shortcut? Ive got Excel 2003 and I dont mean "ALT
+ DOWN" :)
 
D

Dave Peterson

If switching autofilter on/off means to show all the data (but keep the arrows),
then you could add an icon to your favorite toolbar.

Tools|Customize|Commands tab|Data Category
And drag "Show All" and maybe "Autofilter" to that favorite toolbar.
 

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.

Ask a Question

Top