Slicers Design

Well, you’ve built a dashboard, added all the important data, added the Slicer, and now it’s time for the final touch – Slicers design.

We all know that you can change the color of the Slicer from the list of built-in styles:

Slicers Design

(Clicking the arrow will open up a larger list of Slicer styles).

Also, we all know that you can select the number of items that appear in each row, so selecting 2 columns,
for example, will show them in two columns, as you can see here:
pivot table
And basically, these are all the slicer designs you can edit, right?


In fact, you can change and format almost any property,
with a slight reservation – you cannot change the designs and properties of the default Slicers.

So, what do we do?
We create a new Slicer style and design it!

Slicer design – in practice

First, choose the Slicer that appears the most similar to the one we’re looking for, and right-click it > Duplicate:

pivot table excel

The ‘Modify Slicer Style’ window opens, which, true to its name, allows you to change the style.

We will name the new style we created so we can easily identify it:

pivot tables

Now, we can change the formats by selecting the desired property in the Elements box.
For each element, the following formatting pane opens,
Where we can change the different elements in font, border and fill tabs:

excel pivot table

Here’s a tip (this is a change I usually make in all the Dashboards I build):
Since the borders of the Slicers take up a lot of space, I prefer to remove them, in the following way:

From the element list, I choose the element ‘Whole Slicer
I go over to the ‘Border‘ tab and select ‘None

Slicers Design

The Slicer will now appear without borders, and will appear to be an integral part of the worksheet!

In this way you can change different elements: the header, the items selected with the data,
Items that are not selected with the data, change the mouse hover view, and more.

And where do the new slicers appear?
At the top of the Slicer Styles pane.

By the way, hovering over your new slicer style will display its name,
So you can recognize it by the name you gave it.

Finally, for those of you who like to work hard (I personally do not belong to this group …)
You can open the Slicer Styles panel and choose ‘New Slicer Style’.

The New Slicer Style pane opens, where you can format each item individually.

And since most people are not familiar with the possibility to design slicer styles,
I promise you that the dashboards you create will not look like any dashboard that someone else created!

Do you think it was helpful? Share it with your friends