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 WORKBOOK

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)

 

HELPFUL RESOURCES:

JOIN OUR FREE EXCEL COURSES BELOW
Click here to access these FREE Excel courses!

See also  Insert Blank Rows In a Pivot Table

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