Results 1 to 7 of 7
Like Tree1Likes
  • 1 Post By hardeep.kanwar

Keyboard Shortcut to select Filter

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

  1. #1
    New Member
    Join Date
    May 2009
    Posts
    22

    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
    Board Regular hardeep.kanwar's Avatar
    Join Date
    Aug 2008
    Posts
    657

    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
    iamraajkanchan likes this.
    "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
    New Member
    Join Date
    Dec 2009
    Posts
    2

    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
    New Member
    Join Date
    Dec 2009
    Posts
    2

    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
    New Member
    Join Date
    Apr 2013
    Posts
    1

    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
    New Member
    Join Date
    Oct 2013
    Posts
    1

    Default Re: Keyboard Shortcut to select Filter

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

  7. #7
    New Member
    Join Date
    Mar 2014
    Posts
    3

    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