Note that the options only get highlighted when the slicer is selected The next thing that I want to talk about are the options which are available to format the slicer. And there are also options to sort the data or sort it using custom sorting lists.Note that you can also give a custom slicer heading.In Slicer Settings – un-check ‘Display Header’ and check ‘Hide items with no data’.Right click on the Slicer and choose Slicer Settings.There are 2 buttons (North East and South West) that are not active currently, unless you want to show the unactive buttons, it is a good practice to hide them as well.Although the Slicer Heading (Region) is written on the top but it is pretty evident that North, West… are Regions.General guidelines for formatting Slicers.Modifying a Slicer + Its advantages and drawbacks.Slicer Options and Tools : Alignment, Default Styles, Sizes of Buttons and Slicers.

In this post I am going to talk in detail about Now even the default design of the slicers look pretty catchy but when you see the insane possibilities of customizing the looks of the slicer, default formatting becomes a no – no Taking our understanding on slicers a bit further, I today want to talk about formatting slicers. Yesterday I wrote a pretty comprehensive post on creating slicers in Pivot Tables.

Slicer in excel