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:
Here is our Pivot Table:
STEP 1: Go to Design > PivotTable Styles and click the down arrow to open the options
If you want to create a new custom style from scratch, select New PivotTable Style
STEP 2: If you have a starting point in mind, you can right-click on any style and select Duplicate
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.
STEP 4: Try out any formatting that you want. We can try out to change the Fill color. Click OK
STEP 5: You can see a preview of how it looks like. Our first column did change its fill color! Click OK
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
And there you have it!
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 | MyExcelOnline Customising Excel Pivot Table Styles | MyExcelOnline](https://www.myexcelonline.com/wp-content/uploads/2024/07/Bryan-Hong-2-150x150.jpg)
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.