How To Fix Column Widths in an Excel Pivot Table

🎯 Prevent new data spoiling the look of your pivot table by stopping your PivotTable changing columns widths when you refresh it!

Once you get a pivot table looking good the last thing you want is for a pivot table refresh to change pivot table column widths. This is why you should disable pivot table column width refresh and prevent column autofit on refresh. I will demonstrate how to fix column widths in pivot tables and keep the pivot table cell width constant in this Excel PivotTable tutorial. Once you disable pivot table column autofit you will fix pivotable column width and therefore fix pivot table width entirely.

======================================================================================
Transcription
One of the things that used to annoy me about pivot tables was I get it set up looking great and then so maybe I'd do something like this where I say well I'm going to wrap the text on the text on those headers bring them all down ever so slightly double click there yeah that looks pretty good and then I'd hit right click refresh the numbers and it's like well that's annoying this is now jumped out of our sequence because it's just got wider again and it's actually very very simple to correct for this all you do is you go on to the options and there is one of the format options is auto fit columns on update and if you uncheck that and make sure you still got the preserve cell formatting then when I go to change the width of this column I've got all my columns the exact width I want so let's say that right now when i refresh we don't get the column widths jumping around which is ideal so that's a simple tip on how you can stop columns auto expanding once you've got your table looking the way you want you've been watching up for excel where we're going to get your Excel skills up and your task times down you can download the spreadsheet by clicking on the link in the description see you soon.

======================================================================================
#Up4Excel
#Up4PivotTables
#Up4ExcelIntermediate

Here at Up4Excel we’re on a mission to help YOU:
» Get your Excel skills UP and your task time DOWN
» Focus on shortcuts and fast impressive results
» Improve your productivity and free up your time

Everyone will assume you work 24 hours a day to produce the kind of output you’ll be producing in no time…. with the help of Up4Excel training.

We release videos each week, packed full of ways to save time and impress those around you.
💎 Don't miss out and fall behind.....
🅾 SUBSCRIBE NOW 🅾

======================================================================================

======================================================================================

[ytpxp]

The simplest tips are often the most valuable. Many thanks!

[anaredondo]

You made my day! Cheers from Barcelona 😊

[nikolayy]

20 min of my life out the window searching for that video. Thank you.

[wayneedmondson]

Thanks John.. autofit on refresh is super annoying. Thanks for getting the word out on how to change that option. Thumbs up!!

[vishuvishu]

Excellent, this is what i was looking for, thanks alot!

[osmanmalik]

THANKS....VERY SIMPLE...THANKS AGAIN....🤩

[issuefixer]

You saved my time and my life! Thanks a lot, sir! 💝

thank you for this simple but useful tip

[harshavardhana]

WoW thanks you saved my time n effort cheers

[mkparker]

This has been bugging me for so long. Thank you!

[juvyboiser]

This video made my day! I've been trying to fix my pivot table columns width for almost 30mins. Thank you so much for this! HAHAHAH

[gmo]

How do you set column widths if it is every other column and multiple repeating columns like for weekly results? i need to set every other column to a width.

[qdanish]

I have a pivot that keeps on changing the row height everytime I update and refresh, how can I fix it to the one I like

[daviddang]

this doesn't seem to work for me. I'm in using a pivot via data model from power query. I'm assuming that is why.

[lexd]

my issue is that when I select details in the pivot table by double clicking the figures in it, it completely messes up the column widths, even with preserve formatting ticked and autofit unticked

[amreyesv]

Thanks for the video, I disabled it and worked just fine, but now I want to turn it on again and it's not working, no autofit. Hope you can help me.

[vanessaperkins]

That is not working for me. It goes back to the original way. HELP

[MunasibSpace]

it's not working for me. don't really know why.