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....

continue reading »

More Reading

Excel Rearrange fields in a pivot table. Photo Credit: Pierre Châtel-Innocenti at

Excel 2019: Rearrange fields in a pivot table »

April 22, 2019 - by Bill Jelen

The power of pivot tables is the ability to rearrange the fields. If your manager decides you should put Regions across the top and products down the side, it is two drags to create the new report.

Create Your First Pivot Table. Photo Credit: Roman Bozhko at

Excel 2019: Create Your First Pivot Table »

April 18, 2019 - by Bill Jelen

Pivot tables let you summarize tabular data to a one-page summary in a few clicks. Start with a data set that has headings in row 1. It should have no blank rows, blank columns, blank headings or merged cells.

read more articles »

IMA Data Analytics Leveraging Excel

Featured Products

Excel JavaScript UDFs Straight to the Point

Excel JavaScript UDFs Straight to the Point »

JavaScript custom functions - UDFs can be used like any other native functions or UDFs in Excel. This book shows the process of creating JavaScript UDFs in Excel Developer Preview for Office Insider program subscribers.

Your Excel Survival Kit

Your Excel Survival Kit »

This book helps you realize that Excel is on your side. It can be your friend, not your enemy. If and when you upgrade your Excel skills you will experience many positives: you will learn to love Excel, you will learn how to use Excel to become an invaluable asset in your workplace.

Microsoft Excel 2019 Pivot Table Data Crunching

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.

MrExcel LX – The Holy Grail of Excel Tips

MrExcel LX – The Holy Grail of Excel Tips »

A book for people who use Excel 40+ hours per week. Illustrated in full color.

100 Excel Simulations

100 Excel Simulations »

Covering a variety of Excel simulations, from gambling to genetics, this introduction is for people interested in modeling future events, without the cost of an expensive textbook.

Power Excel With MrExcel - 2017 Edition

Power Excel With MrExcel - 2017 Edition »

This is the print book edition of "Power Excel with MrExcel - 2017 Edition" - by Bill Jelen. Master Pivot Tables, Subtotals, Visualizations, VLOOKUP, Power BI and Data Analysis.

see more products »