This is a discussion on Keyboard Shortcut to select Filter within the Excel Questions forums, part of the Question Forums category; I am using excel 2007. does anybody know a shortcut key to click the arrow down after you filter. What ...
I am using excel 2007. does anybody know a shortcut key to click the arrow down after you filter.
What I mean is when I press Ctrl+shift+L I get the filter, but then I have to use the mouse and click the arrow down to view the selection, then I have to use the mouse again to unselect the "Select All" button. from there i know how to select the number using the keyboard.
I use this a lot through out the day and wish I can only use the keyboard.
Let me bump this.
Same problem and ALT + DOWN ARROW doesn't help; that just pops up another filter with all the items in that column.
What I would like to do is open the filter controls that are accessible by clicking the little down arrow button that appears at the top of each filtered column.
One must go to the cell (usually the first row) where the little down arrow icon appears and THEN hit ALT + DOWN ARROW
Thanks bairagisanjeev! This is something I've been pondering about for a long time!
Thanks Hardeep Kanwar