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

 

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

Select Columns to 3.

Add Columns to Pivot Table Slicer Buttons | MyExcelOnline

 

Your slicer now has a 3-column button layout!

Add Columns to Pivot Table Slicer Buttons | MyExcelOnline

Add Columns to Pivot Table Slicer Buttons:

 

HELPFUL RESOURCE:

Add Columns to Pivot Table Slicer Buttons | MyExcelOnline

 

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

Add Columns to Pivot Table Slicer Buttons | MyExcelOnline