Custom Style of Slicers
Excel Tips and Tricks

Custom Style of a slicer in Excel

In this article you will learn how to create a custom style for a Slicer. By using the custom style in Slicer you can make your slicer based dashboard or report more visually attractive and beautiful.

How to create a custom style for a slicer?

Let’s say we have a slicer for locations.

Slicer
Slicer
  • Select the slicer.
  • Go to Options>>Slicer Styles>>Click on New Slicer Style.
New Slicer Style Option
New Slicer Style Option
  • New Slicer Style window will be opened
  • Give the formatting for –
    • Whole Slicer
    • Header
    • Selected Item with Data
    • Selected Item with no Data
    • Unselected Item with Data
    • Unselected Item with no Data
    • Hovered selected Item with Data
    • Hovered selected Item with no Data
    • Hovered unselected Item with Data
    • Hovered unselected Item with no Data
New Slicer Style window
New Slicer Style window
  • In the Format Slicer Element window you can give background color, font color, font size, font name, font style and borders etc.
Format Slicer Element window
Format Slicer Element window
  • Once setting is complete of slicer style, it will be available under Custom of Slicers style.

 

Click here to download this excel file.

 

Watch step by step video tutorial to learn how to create custom style for a slicer

PK
My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 10 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.
https://www.pk-anexcelexpert.com

Leave a Reply

Your email address will not be published. Required fields are marked *