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.

 

UPDATE

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

slice1

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

slice2

Duncan Williamson

One Response to “Excel Slicer”


Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: