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

50 Things You Can Do With Excel Pivot Tables Pivot Tables in Excel are one of the most powerful features within Microsoft Excel.   A Pivot Table allows you to analyze more than 1 million rows of data with just a few mouse clicks, show the results in an easy to read table, "pivot"/change the report layout with the ease of dr...
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...
Conditionally Format a Pivot Table With Data Bars Data Bars are a new Conditional Formatting feature in Excel 2010 and they add a colored bar to your values.The length of the data bar represents the value in the cell.  A longer bar represents a higher value.You have a Gradient Fill or a Solid Fill to choose from as well ...
Top 3 Excel Pivot Table Issues Resolved I have shown my Free Pivot Table webinar to over 40,000 people over the last couple of years and I continually get the same questions from my webinar attendees regarding the little issues they have when using a Pivot Table.I want to put these issues to bed so you can go o...