Pinterest Pixel

Add Columns to Pivot Table Slicer Buttons

When you insert an Excel Slicer with your Pivot Table it defaults to one column, showing all your items... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

Add Columns to Pivot Table Slicer Buttons | MyExcelOnline Add Columns to Pivot Table Slicer Buttons | MyExcelOnline

When you insert an Excel Slicer with your Pivot Table it defaults to one column, showing all your items in a vertical layout.

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
Add Columns to Pivot Table Slicer Buttons | MyExcelOnline Add Columns to Pivot Table Slicer Buttons | MyExcelOnline

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