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

Group By Custom Dates With Excel Pivot Tables In my previous Group By Month post, we grouped our Sales by each month.However the cool thing with Excel is that we can take that a step further and customize our grouped date range!In the example below I show you how to get the Sales Grouped by Custom Dates:  ...
The Ultimate Guide to Excel Pivot Table Slicers Slicers were first introduced in Pivot Tables in Excel 2010 for Windows and Excel 2016 for Mac.Pivot Table Slicers are a visual filter in the form of an interactive button.  There are several cool things that you can do with Pivot Table Slicers, like customize them, filter th...
Show The Percent of Row Total With Excel Pivot Tab... 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 ROW TOTAL calculation.This option will immediately calculate the percentages for you from a table filled with numbers such as sales data, exp...
Use An External Data Source To Import Data Into An... When creating an Excel Pivot Table, what happens if your data source is in another location?Would you have to copy your data into the same spreadsheet?Well, NO!  You can simply use the External Data Sources feature in your Pivot Table and Excel will magically import the d...