The default Pivot Table style in Excel is very bland and boring, stemming from a lack of creativity from the nerds over at Microsoft!

You can give some life to your Excel Pivot Table by simply changing the Pivot Table Style!

For our example, this is our Pivot Table:

DOWNLOAD EXCEL WORKBOOK

STEP 1: Make sure you have your Pivot Table selected. Go to PivotTable Tools > Design > PivotTable Styles

 

STEP 2: Expand the styles list and have fun selecting your preferred style! You can see I selected the orange style below, as today is a hot day 🙂

You now have your Excel Pivot Table with your new warm style!

 

How to Change Pivot Table Styles in Excel

Helpful Resource:

Excel Pivot Table

 

 

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 Connection Option Greyed Out For Excel Pivo... Sometimes when you create a Pivot Table and want to insert a Slicer you are unable to do this as the Slicer button is greyed.You try to click on the Slicer button but nothing happens.What gives??There are two things that can cause your Slicer connection to be grey...
Group By Quarters and Years With Excel Pivot Table... Ever encountered needing a quick report of total sales numbers by each quarter, of each year?I was faced with this same scenario and looking at my data on hand, I only had sales numbers for each individual day.Grouping these would take a ton of effort & complex formul...
Sort an Item Row (Left to Right) With Excel Pivot ... I knew that I could sort virtually anywhere with Excel Pivot Tables, but I was surprised that I could even sort any row from left to right!!Below I have an Excel Pivot Table that consists of Sales Numbers over a three year period.Make sure to download the Excel Workbook b...
Show The Percent Of With Excel Pivot Tables  Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF calculation.It will display the value of one item (the Base Field) as the percentage of another item (the Base Item).This optio...