View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Keyboard shortcut for Auto-filter

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.

Wombat wrote:

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" :-)


--

Dave Peterson