Excel slicer keyboard shortcuts?
Results 1 to 5 of 5

Thread: Excel slicer keyboard shortcuts?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Sep 2015
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Excel slicer keyboard shortcuts?

    I am using a slicer to filter pivot table data into a graph and am wondering if there is a way to step through the slicer fields one at at time with a keyboard shortcut?

  2. #2
    Board Regular
    Join Date
    Jun 2015
    Location
    Geneva, Switzerland
    Posts
    136
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel slicer keyboard shortcuts?

    You can select a slicer then hit TAB twice so there is a dotted square around the first value of the slicer, then you can play around with arrows, CTRL, SHIFT, SPACE. If you keep hitting tab you can also browse to other slicers.
    Give me six hours to chop down a tree and I will spend the first five building something that will do it for me.

  3. #3
    New Member
    Join Date
    Sep 2015
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel slicer keyboard shortcuts?

    Occam's razor...I overlooked basic keyboard actions. Thank you!!

  4. #4
    Board Regular
    Join Date
    Jun 2015
    Location
    Geneva, Switzerland
    Posts
    136
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel slicer keyboard shortcuts?

    Glad I could help!
    Give me six hours to chop down a tree and I will spend the first five building something that will do it for me.

  5. #5
    . MrExcel's Avatar
    Join Date
    Feb 2002
    Location
    Merritt Island Florida
    Posts
    872
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Excel slicer keyboard shortcuts?

    I am adding to this old thread because I arrived here when trying to figure out how to activate a slicer without using the Mouse. I finally figured it out. It is very subtle and I wanted to document it somewhere so I would not forget it.

    In my example, I have a pivot table in A3:B17. I added a Sales Rep slicer, then an oval shape, then a star shape, then a Product slicer. I am starting from a cell in the pivot table.

    1. Press Alt, H, FD, and then the letter O to enter Select Objects mode. Not much appears to happen, but the cell pointer changes to a white arrow instead of a black cross.

    2. Press Tab once to select the Sales Rep slicer. At this point, you've selected the container for the slicer, so the arrow keys will move the entire slicer .

    3. Press Tab again to move into the slicer, first to the Multi-Select icon added in Excel 2016. Spacebar will toggle the Multi-Select state.

    4. Press Tab again to move to the Clear Filter icon. Press spacebar to clear the filter.

    5. Press Tab again to move into the slicer items. This is where I was trying to get. Be very cautious here because you don't automatically move to the first slicer tile. You move to the last slicer tile that was touched. How can you tell which slicer is active? There is a light dotted border on that dark blue slicer and it is almost impossible to see. Press the arrow keys a few times and maybe you will see the subtle formatting moving. Now that you are in the slicer tiles, using arrows will move among them. If you enabled Multi-Select, then pressing spacebar will toggle the selected slicer item. If you forgot to enable Multi-Select, then choosing one slicer tile will turn off all the other tiles. From here, you can Shift+Tab once or twice to move back to the Clear Filter and Multi-Select icons.

    6. Press Tab again to leave this slicer. In my case, I move to the Oval shape.

    7. Press Tab again to move to the Star shape.

    8. Press Tab again to move to the Product Slicer. You are now essentially at step 2 again.

    When you are done selecting from slicers, you have to get out of the Select Objects mode. Press Escape and you will return to the last selected cell in the pivot table.
    View a collection of recent Excel articles in the Excel Daily News

Some videos you may like

User Tag List

Tags for this Thread

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
  •