+ Reply to Thread
Results 1 to 10 of 10

Multiple slicer selections

  1. #1
    Registered User
    Join Date
    12-06-2018
    Location
    York
    MS-Off Ver
    2010
    Posts
    6

    Multiple slicer selections

    Hi,

    I'm trying to work out how I can enable users to select two filter options in a slicer without having to hold down Ctrl.

    I either need people to be able to select two things at once or find a way to lock one option as I need that to be selected every time and users are then able to select the second accompanying option.

    I'm using Excel 2010 on a PC not a MAC.

    I'm a basic pivot table user so please word your answers at dummy level so I can follow!

    Thanks for any help
    S

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    4,648

    Re: Multiple slicer selections

    Hello and welcome to the forum.

    You can either select multiple slicer selections using the Ctrl key or by clicking on the Multi-Select button toward the top-right part of the slicer window.

  3. #3
    Registered User
    Join Date
    12-06-2018
    Location
    York
    MS-Off Ver
    2010
    Posts
    6

    Re: Multiple slicer selections

    Thanks for your quick reply. I'm trying to avoid having to hold down the ctrl key as I know my audience and they panic at having remember to do anything at all to make things work, even instructions as simple as this!

    There is no multiple selection option on my slicer at the top right, just the filter icon? my slicer is a list of areas and I basically need the 'national' option to always be selected and then users able to change between all the other areas whilst always keeping national selected.

  4. #4
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    4,648

    Re: Multiple slicer selections

    https://office-watch.com/2017/multip...l-pivottables/

    Scroll down to the "Multi-Select" section. Are you seeing something different?

  5. #5
    Registered User
    Join Date
    12-06-2018
    Location
    York
    MS-Off Ver
    2010
    Posts
    6

    Re: Multiple slicer selections

    Ah no that option does not appear on my slicer I only have the filter deselect icon

  6. #6
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    4,648

    Re: Multiple slicer selections

    Interesting. Maybe that feature is not in Excel 2010. I'm not sure since I am using Excel 2016.

    You can always select multiple items from the Pivot Table filter (not slicer). This is outlined in the link from post #4 as well.

  7. #7
    Registered User
    Join Date
    12-06-2018
    Location
    York
    MS-Off Ver
    2010
    Posts
    6

    Re: Multiple slicer selections

    I think it is probably a limitation of the 2010 version maybe, it's my work system and we are due to be upgraded in the new year so hopefully that will fix it for me, it's annoying though.

    I don't think I can use the filter function as I have the slicer linked to about 10 tables so they all change at once with one selection.

    Thanks for trying

  8. #8
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    4,648

    Re: Multiple slicer selections

    You're welcome.

    Due to the version limitations, it looks like your best bet will be for your group to use the Ctrl key to make multiple slicer selections until you are upgraded.

  9. #9
    Registered User
    Join Date
    12-06-2018
    Location
    York
    MS-Off Ver
    2010
    Posts
    6

    Re: Multiple slicer selections

    I might post in the VBA forum to see if anyone has any fancy code that might help me!

  10. #10
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016/Work 2013 Pro Plus
    Posts
    1,553

    Re: Multiple slicer selections

    Write a note next to the slicer, saying Hold Ctrl to select multiple items.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1