Results 1 to 7 of 7

Thread: Keyboard Shortcut to select Filter

  1. #1

    Default Keyboard Shortcut to select Filter

    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.
    [IMG]file:///C:/Users/isabel/AppData/Local/Temp/moz-screenshot.jpg[/IMG]

  2. #2

    Default Re: Keyboard Shortcut to select Filter

    Quote Originally Posted by isabel802 View Post
    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.
    [IMG]file:///C:/Users/isabel/AppData/Local/Temp/moz-screenshot.jpg[/IMG]
    Try

    Alt+Down Arrow.

    To close Filter dropdown list press Alt+Up Arrow
    "PEOPLE LAUGH BECAUSE I AM DIFFERENT..AND I LAUGH BECAUSE THEY ARE ALL THE SAME.. THATS CALLED"ATTITUDE""-SWAMI VIVEKANANDA



    Hardeepkanwar

    Using Excel 2007

  3. #3

    Default Re: Keyboard Shortcut to select Filter

    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.



  4. #4

    Default Re: Keyboard Shortcut to select Filter

    EUREKA!

    One must go to the cell (usually the first row) where the little down arrow icon appears and THEN hit ALT + DOWN ARROW

    Doh....

  5. #5

    Default Re: Keyboard Shortcut to select Filter

    Quote Originally Posted by equinexus View Post
    EUREKA!

    One must go to the cell (usually the first row) where the little down arrow icon appears and THEN hit ALT + DOWN ARROW

    Doh....

    Hey..I understood your question.. when you select ALT Down Arrow button just press space bar to select or unselect filter/drop down options in your excel sheet...

    Hope you get it...Happpyyyyyyy

  6. #6

    Default Re: Keyboard Shortcut to select Filter

    Thanks bairagisanjeev! This is something I've been pondering about for a long time!

  7. #7

    Default Re: Keyboard Shortcut to select Filter

    Thanks Hardeep Kanwar

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com