Pinterest Pixel

Add Columns to Pivot Table Slicer Buttons

John Michaloudis
When you insert an Excel Slicer with your Pivot Table it defaults to one column, showing all your items in a vertical layout.
Add Columns to Pivot Table Slicer Buttons | MyExcelOnline Add Columns to Pivot Table Slicer Buttons | MyExcelOnline

Say that your Pivot Table Slicer is showing months from January to December.  You can change the layout of the buttons to show in 3 separate columns, turning it into a “Quarterly View”.

I explain how to add columns to your Pivot Table Slicer buttons below.  Download our workbook to follow along:

Add Columns to Pivot Table Slicer Buttons | MyExcelOnline

download excel workbookSlicer-Columns.xlsx

STEP 1: Select your Slicer.

Add Columns to Pivot Table Slicer Buttons

 

STEP 2: Go to Slicer Tools > Options > Buttons > Columns 

Select Columns to 3.

Add Columns to Pivot Table Slicer Buttons

 

Your slicer now has a 3-column button layout!

Add Columns to Pivot Table Slicer Buttons

Add Columns to Pivot Table Slicer Buttons:

 

5 Speedy Steps To An Excel Pivot Table! (infographic)

 

If you like this Excel tip, please share it
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  Group Sales with a Pivot Table

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...