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

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

Bill Jelen is the author / co-author of
Microsoft Excel 2019 Pivot Table Data Crunching

Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you’ve never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power–including valuable improvements in Excel 2019 and Excel in Office 365.