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+

Related Posts

Show the Difference From Previous Month with Direc... Using a Pivot Table you can show the variance from your previous month's sales very easily... See how to Show The Difference From Previous Months With Excel Pivot Tables here Now that we have the Pivot Table report above, we can show the variances per month using an up/...
Errors When Grouping By Dates With Excel Pivot Tab... In our Group By Date post, we grouped our sales numbers by weeks. However there are times when we try to group by Dates and we get an error message!  That is frustrating! Instead of checking the dates one by one to find out where the error occurred, I will show you a cool w...
Classic Pivot Table Layout View For all of you old schoolers out there who used to use the drag and drop Pivot Table option in Excel 2003 or prior, well you still have that option in Excel 2010 and onwards. To activate this option you need to Right Click in your Pivot Table and choose Pivot Table Options. ...
How To Insert a Pivot Table Slicer Slicers in Excel are visual filters or interactive buttons that allow you to see what items have been chosen within a Pivot Table. They are a new feature from Excel 2010 onward and Mac for Excel 2016 and a must for anyone wanting to wow their boss by adding interactivity i...