MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2019: Format a Pivot Table


April 24, 2019 - by Bill Jelen

Excel Format a Pivot Table. Photo Credit: 五玄土 ORIENTO at Unsplash.com

You might wonder how the pivot table above changed from green to orange. The Design tab has a gallery with 84 built-in formats for pivot tables. Choose a design from the gallery and the colors change.

There are two tabs in the Ribbon for PivotTable Tools. The second tab is called Design and offers a gallery with different color schemes.

One frustrating feature with a pivot table is that the numbers always start out as General format. Right-click any number and choose Number Format....


Any changes you make to the number formatting using this command will be remembered as long as Revenue stays in the pivot table. (Before Excel 2010, pivot tables would frequently forget the number formatting. This was fixed in Excel 2010.)

Right-click any numeric cell in the pivot table and choose Number Format.

Title Photo: 五玄土 ORIENTO at Unsplash.com


Bill Jelen is the author / co-author of
Excel Insights – A Microsoft MVP Guide to the Best Parts of Excel

There are fewer than 100 Excel MVPs worldwide. 24 of them have contributed to this book. Written, edited, reviewed and printed by Excel MVPs, this is practical Excel passion undiluted, with each MVP highlighting some of their favorite topics.