Each time you Refresh a Pivot Table you will most likely get annoyed at the fact that the column widths that you worked so hard to align – will return back to normal 🙁

Do not fear, Pivot Table Options is here!

All you need to do is Right Click in the Pivot Table and choose PivotTable Options and then under the Layout & Format tab you need to “uncheck” the box that says: Autofit column widths on update

Next time you update your data and Refresh your Pivot Table, the column width will never change 🙂



STEP 1: Right click in the Pivot Table and select Pivot Table Options


STEP 2: Uncheck Autofit Column Widths on Update


STEP 3: Update your data


STEP 4: Refresh your pivot table

Our Pivot Table column widths do not change anymore!

Keep Column Width Upon Refresh



If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn


Share on Google+


Related Posts

5 Speedy Steps To An Excel Pivot Table! (infograph... G'day All, In this free downloadable Excel Pivot Table Cheat Sheet/Infographic, I show you how easy it is to create an Excel Pivot Table in 5 Speedy Steps...Enjoy and please comment below if you have any Excel or Pivot Table questions, I'm here to help you 🙂 DOWNLOAD ...
Classic Pivot Table Layout View For all of you old schoolers out there who used to use the drag and drop Pivot Table option in Excel 2003 or prior, well you still have that option in Excel 2010 and onwards. To activate this option you need to Right Click in your Pivot Table and choose Pivot Table Options. ...
Insert Blank Rows In a Pivot Table Pivot Table reports are shown in a Compact Layout format as a default and if you have two or more Items in the Row Labels (e.g.Month & Customer), then the Pivot Table report can look very clunky... There is a cool little trick that most Excel users do not know about th...
Free Pivot Table Webinar Hey there, I have been having a huge response to this highly acclaimed Pivot Table webinar and will continue to give these lessons in to the new year!  If a date is not suitable for you, you can always come back to the Registration link below on a future date.  Happy Pivot...