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](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ExcelTips/Custom_Slicer_Style/Custom-Slicers-2.jpg)
- Select the slicer.
- Go to Options>>Slicer Styles>>Click on New Slicer Style.
![New Slicer Style Option](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ExcelTips/Custom_Slicer_Style/Custom-Slicers-3.jpg)
- 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](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ExcelTips/Custom_Slicer_Style/Custom-Slicers-4.jpg)
- 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](https://www.pk-anexcelexpert.com/wp-content/uploads/Blogs/ExcelTips/Custom_Slicer_Style/Custom-Slicers-5.jpg)
- Once setting is complete of slicer style, it will be available under Custom of Slicers style.
Click here to download this excel file.