Customize Pivot Table Default Layout Style

When you create a PivotTable it defaults to certain views and if you create Pivot Tables often you probably adjust it a lot. Maybe you don't like the compact Pivot layout with it's nested view and prefer Tabular with repeated row values. Once the Pivot table is created you can manually change it by going into Options and changing it for each feature which this video will cover. That works if you don't create Pivot Tables that much, but if you do create them often and don't want to always click and select everytime just make those views the default. When you go into the Backstage view in Excel, just adjust the default settings and they will apply every time you create a Pivot and become your new Pivot Table defaults. Check out the video to learn how to customize this now.

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

#excel
#msexcel
#doughexcel

-~-~~-~~~-~~-~-
Please watch: "Convert Table in a PDF File to Excel"
-~-~~-~~~-~~-~-

[eddieb]

Those option do not appear in earlier versions of Excel (I'm using 2016), so maybe qualify that in the video title...(..2019 only..?)...

[excelisfun]

Killer Thumb Nail!!! You have been killing it at those for a while now : ) : )

[gopigopichand]

You are awesome.. thanks for sharing those awesome tips..

[ALAORYT]

Very interisting. Thanks for your videos. They are very very interesting. All of them. Thank you.

[wayneedmondson]

Hi Doug.. great tips.. they solve a lot of frustrations with the default Pivot Table settings. Thanks for sharing your knowledge. Thumbs up!