There are several different Slicer Styles available for you when you click on an Excel Slicer.

These Slicer Styles add color to your Excel workbook to gives it some much needed life!

You can also add columns to a Slicer and you can also find more Slicer options by Right Clicking on a Slicer.

I will show you how easy it is to choose the different Pivot Table Slicer Styles:



STEP 1: Select your Slicer.


STEP 2: Go to Slicer Tools > Options > Slicer Styles

Select a style you prefer by clicking on it with your mouse.

If you do not like the chosen Style, just follow the process above and choose another color!


Your Pivot Table Slicer now has come to life!

Slicer Styles & Settings:

Slicer Styles & Settings

Helpful Resource:



If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Drill Down To Audit Using a Pivot Table When you are using a Pivot Table in Excel and want to know what data makes up a certain value, all you have to do is double click on that cell.This will open up a brand new Sheet with all the rows of data that make up that value.NB. This is an extraction of your data sour...
Refresh a Pivot Table When the information in your data set gets updated you need to Refresh your Pivot Table to see those changes in your Pivot Table.  There are three ways to do this.  First click on your Pivot Table and:1. From the Ribbon choose: PivotTable Tools > Options > Refresh2....
Pivot Table Calculated Item Pivot Table Calculated Items allow you to do mathematical calculations with your Item List.  You can use any of the Excel mathematical equations, like /*+-%.The only limitation is that you cannot reference any cells.  Pivot Table Calculated Items can be used to calculate chan...
Sorting a Pivot Table There are a few ways that you can Sort a Pivot Table.  You can Sort the Row/Column Labels as well as Values within a Pivot Table.  Below I show you three quick ways...DOWNLOAD WORKBOOKHelpful Resource: