Pivot Table Format Defaults

December 13, 2022 - by Bill Jelen

Problem: I hate Compact layout in Pivot Tables. I want all future pivot tables to start in Tabular.

Strategy: A November 2016 update to Office 365 introduces the ability to set defaults for all future pivot tables. Go to File, Options, Advanced, Data and choose Edit Default Layout.

File, Options, Data now has a button for Edit Default Layout. — Figure 862. After years of lobbying and 1000 votes at Excel.UserVoice.com, this feature was added.

Gotcha: If you have an older version of Excel, you can buy the Pivot Power Premium add-in from Debra Dalgleish at Contextures.com. This add-in addresses many annoyances with pivot tables. Read more at http://www.mrx.cl/pppdebra.

This article is an excerpt from Power Excel With MrExcel

Title photo by André Roma on Unsplash