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

Show The Percent of Grand Total With Excel Pivot T...   Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF GRAND TOTAL calculation. This option will immediately calculate the percentages for you from a table filled with numbers such as sal...
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...
Group By Month With Excel Pivot Tables Before I was a Pivot Table guru, I had to get individual rows of daily sales and group them into a report showing the monthly sales during the year. Grouping these would take a ton of effort using Formulas: Extracting the month and year from each transactional date; Th...
Show Averages With an Excel Pivot Table A Pivot Table is the most powerful feature within Excel as it allows you to analyze your data in many different ways, all with a press of a button. The Summarize Values By option allows you to choose a type of calculation (Sum, Count, Average, Max, Min, Count Numbers Produ...