PAGE UPDATED 27th July 2014

It’s taken me a long time to write about them but I have finally to round the part of my book that includes Pivot Table Slicers. I think the average Excel user will be surprised to learn what can be done with a bit of effort and some creativity. Here’s a screenshot of a simple dashboard set up with some slicers that you will see in my book.



I don’t always learn the far end of everything when I learn a technique in Excel. Slicers is a case in point. I know slicers quite well and can use them very effectively. I demonstrate slicers a few times a year to my training course audiences. Following a question on slicers this week, however, I answered the question is it possible to make the slicer read from Z to A rather than A to Z?

The answer turns out to be simple:

  • select a slicer
  • right click it
  • in the menu you will now see
    • Sort A to Z
    • Sort Z to A
  • … make your choice of the order you prefer


Alternatively, see the screenshot below to enable you to use the Slicer Tools Options Tab, Slicer Settings dialogue box:


Duncan Williamson

3 Responses to “Excel Slicer”

  1. Hmm is anyone else encountering problems with the images on this blog loading? I’m trying to determine if its a problem on my end or if it’s the blog. Any suggestions would be greatly appreciated.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: