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

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Group Sales with a Pivot Table A Pivot Table allows you to Group your transactional sales values by any range that you want.  You can then summarize each sales group and see the total sales and the number of transactions that they have produced.  This is useful for pricing analysis. DOWNLOAD WORKBOOK ...
Show the Difference From Previous Month with Direc... Using a Pivot Table you can show the variance from your previous month's sales very easily... See how to Show The Difference From Previous Months With Excel Pivot Tables here Now that we have the Pivot Table report above, we can show the variances per month using an up/...
Distinct or Unique Count with Excel Pivot Tables Excel 2013 added some new features to its arsenal and one that has been well overdue was the distinct or unique count. Previously when we created a Pivot Table and dropped a Customers field in the Row Labels and then again in the Values area we got the "total number of transac...
Connect Slicers to Multiple Excel Pivot Tables Pivot Table Slicers were first introduced in Excel 2010 for Windows and Excel 2016 for Mac. They are a visual filter in the form of an interactive button.  There are several cool things that you can do with Slicers, like customize them, filter them and connect them to mult...