ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Keyboard shortcut for Auto-filter (https://www.excelbanter.com/excel-discussion-misc-queries/260984-keyboard-shortcut-auto-filter.html)

Wombat

Keyboard shortcut for Auto-filter
 
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

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


All times are GMT +1. The time now is 04:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com