Prev: Area Charts in 2007 - how to bring data set to front?
Next: Sumproduct to count between two dates
From: Wombat on 8 Apr 2010 09:54
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" :-)
From: Dave Peterson on 8 Apr 2010 10:51
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
 | 
Pages: 1
Prev: Area Charts in 2007 - how to bring data set to front?
Next: Sumproduct to count between two dates