Excel Slicers are very boring looking and there are only 14 different Slicer Styles to choose from, ranging from Light to Dark and with a few colors to choose from.

What if you wanted to create your own Slicer using your creative mind with super cool colors and fonts?

Well you can!

This is how you can achieve this with just a few simple steps:

STEP 1: You need to select the Excel Slicer and go to the Slicer Tools tab and choose Options;

STEP 2: Under the Slicer Styles drop down, Right Click on the highlighted Slicer and choose Duplicate;

STEP 3: Select a Slicer Element and click on the Format button;

There are several Slicer Elements which can become very confusing.  I have tried to explained the different options with images in this Downloadable Workbook: Slicer Elements

STEP 4: Make the necessary formats and then press OK to go out of the Modify Slicer Style dialogue box;

STEP 5: To see the custom changes you need to select the newly created custom Slicer from the Slicer Styles drop down box.

DOWNLOAD WORKBOOK

Create a Custom Slicer

HELPFUL RESOURCE:

728x90

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

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

5 Speedy Steps To An Excel Pivot Table! (infograph... G'day All,In this free downloadable Excel Pivot Table Cheat Sheet/Infographic, I show you how easy it is to create an Excel Pivot Table in 5 Speedy Steps...Enjoy and please comment below if you have any Excel or Pivot Table questions, I'm here to help you 🙂DOWNLOAD ...
Pivot Table Calculated Field Pivot Table Calculated Fields allow you to do mathematical calculations with your Field List.  You can use any of the Excel mathematical equations, like /*+-%.The only limitation is that you cannot reference any cells.  Pivot Table Calculated Fields can be used to calculate p...
Slicer Styles & Settings 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...
How To Insert a Pivot Table Slicer Slicers in Excel are visual filters or interactive buttons that allow you to see what items have been chosen within a Pivot Table.They are a new feature from Excel 2010 onward and Mac for Excel 2016 and a must for anyone wanting to wow their boss by adding interactivity i...