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: