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:

DOWNLOAD EXCEL WORKBOOK

STEP 1: Select your Slicer.

 

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

Select Columns to 3.

 

Your slicer now has a 3-column button layout!

Add Columns to Pivot Table Slicer Buttons:

Slicer Columns

HELPFUL RESOURCE:

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Slicer Styles & Settings There are several different Slicer Styles available for you when you click on an Excel Slicer.These Slicer Styles add color to your Excel workbook to gives it some much needed life!You can also add columns to a Slicer and you can also find more Slicer options by Right...
GETPIVOTDATA Function What does it do?A formula that extracts data stored in a Pivot TableFormula breakdown:=GETPIVOTDATA(data_field, pivot_table, , ,...)What it means:=GETPIVOTDATA(return me this value from the Values Area, any cell within the Pivot Table, ,...) T...
Free Pivot Table Webinar Hey there,I have been having a huge response to this highly acclaimed Pivot Table webinar and will continue to give these lessons in to the new year!  If a date is not suitable for you, you can always come back to the Registration link below on a future date.  Happy Pivot...
Pivot Table Report Layouts Pivot Tables have three different layouts that you can choose from: Compact, Outline and Tabular Form.You can choose from each layout by clicking in the Pivot Table and going to PivotTable Tools > Design > Report LayoutsThey each have their advantages and disadvanta...