+ Reply to Thread
Results 1 to 3 of 3

'select all' option in slicer

  1. #1
    Registered User
    Join Date
    08-25-2011
    Location
    Albany, New York
    MS-Off Ver
    Excel 2007
    Posts
    48

    'select all' option in slicer

    Hi
    I have a slicer for a pivot table that I would like to include a 'select all' option, however, I don't see this as an option in the slicer configuration.

    Does anyone know if there is a way to do this?

    Paul

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: 'select all' option in slicer

    Hi Paul,

    Slicer means "slice" not the entire bread
    So if you want a "select all" option.. suggest you to have an extra column. for example.. if you have onion, chilly, carrot and you need to show all "vegetables" in one go... create an extra column in you data source by the name of "vegetable" and then you can use that in Slicer. Thanks.

    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: 'select all' option in slicer

    I am no doubt saying something blatantly obvious already but if you de-select everything in the Slicer it will show everything.

    In other words clearing the filter on the slicer (top right) will select everything.

+ 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