MrExcel.com - Your One Stop for Excel Tips & Solutions

Excel 2020: Format a Pivot Table

April 27, 2020 - by

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

This article is an excerpt from MrExcel 2020 - Seeing Excel Clearly.