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

Show & Hide Field List in Excel Pivot Table Have you ever had the scenario where you are working on your Pivot Table and the Field List disappears?Lots of Excel users get annoyed with this but luckily I'm here to help you out 🙂If your Pivot Table Field List disappears, you can easily bring it back as I show you be...
What Microsoft Excel Version Do I Have? We know that Microsoft Excel has different features across different versions and there are several Excel version, like Excel 2003, 2007, 2010, 2013 and 2016!So whenever I use Microsoft Excel I want to know right away which Excel Version I am using.  And boy, do I get confuse...
Group By Half Years With Excel Pivot Tables  In our previous post, we were able to Group by Month using Pivot Tables.  Let us take it up another notch, and group it by Half Years!In the example below I show you how to get the Sales Grouped by Half Years: January to June and July to December DOWNL...
Refresh All for Excel Pivot Tables When the information in your data source gets updated or changed, you need to Refresh your Pivot Table to see those changes in your Pivot Table.How about if you have multiple Pivot Tables from the same data source in the same workbook? Or;Pivot Tables that are created fro...