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

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+