Pinterest Pixel

Customising Excel Pivot Table Styles

Bryan
There are a lot of Pivot Table Styles to choose from when you want to change the look and feel of your Pivot Table.
Customising Excel Pivot Table Styles | MyExcelOnline Customising Excel Pivot Table Styles | MyExcelOnline

What if even with this multitude of predefined options, you still want to make your own style? You can easily do that by customising pivot table styles. There are a couple of ways to do this!

 

Exercise Workbook:

Download excel workbookCustomising-a-Pivot-Table-Style.xlsx


Here is our Pivot Table:

Customising Excel Pivot Table Styles

STEP 1: Go to Design > PivotTable Styles and click the down arrow to open the options

Customising Excel Pivot Table Styles

If you want to create a new custom style from scratch, select New PivotTable Style

Customising Excel Pivot Table Styles

STEP 2: If you have a starting point in mind, you can right-click on any style and select Duplicate

Customising Excel Pivot Table Styles

STEP 3: Change the Name into your own preference. There are a lot of elements you can format!

For our example, let us try out First Column. Select that and click Format.

Customising Excel Pivot Table Styles

STEP 4: Try out any formatting that you want. We can try out to change the Fill color. Click OK

Customising Excel Pivot Table Styles

STEP 5: You can see a preview of how it looks like. Our first column did change its fill color! Click OK

Customising Excel Pivot Table Styles

STEP 6: The new style that we created is not applied yet automatically.

To use that, go to Design > PivotTable Styles and select the new style that we have created

Customising Excel Pivot Table Styles

And there you have it!

Customising Excel Pivot Table Styles

I have also created this diagram for you to immediately see the different Pivot Table Elements. Have fun creating and customising pivot table styles!

Customising Excel Pivot Table Styles

 

If you like this Excel tip, please share it
Customising Excel Pivot Table Styles | MyExcelOnline
Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.

See also  Unleashing the Power of Pivot Tables in Excel: A Practical Guide

Star 30 Days - Full Access Star

One Dollar Trial

$1 Trial for 30 days!

Access for $1

Cancel Anytime

One Dollar Trial
  • Get FULL ACCESS to all our Excel & Office courses, bonuses, and support for just USD $1 today! Enjoy 30 days of learning and expert help.
  • You can CANCEL ANYTIME — no strings attached! Even if it’s on day 29, you won’t be charged again.
  • You'll get to keep all our downloadable Excel E-Books, Workbooks, Templates, and Cheat Sheets - yours to enjoy FOREVER!
  • Practice Workbooks
  • Certificates of Completion
  • 5 Amazing Bonuses
Satisfaction Guaranteed
Accepted paymend methods
Secure checkout

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...