Pinterest Pixel

Customize an Excel Slicer

Excel Slicers are very boring looking and there are only 14 different Slicer Styles to choose from, ranging... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

Customize an Excel Slicer | MyExcelOnline Customize an Excel Slicer | MyExcelOnline

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 tab

Customize an Excel Slicer

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

Customize an Excel Slicer

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 explain the different options with images in this Downloadable Workbook: Slicer elementsSlicer-Elements1.xlsx

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

Customize an Excel Slicer

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

Customize an Excel Slicer

Watch it in action below!

Customize an Excel Slicer | MyExcelOnline
Download workbookCreate-a-Custom-Slicer.xlsx

Further Learning:

728x90

If you like this Excel tip, please share it
Customize an Excel Slicer | MyExcelOnline Customize an Excel Slicer | MyExcelOnline
Founder & Chief Inspirational Officer at

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.

See also  Unleashing the Power of Pivot Tables in Excel: A Practical Guide

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...