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.
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.