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 🙂

Fix Column Width in a Pivot Table | MyExcelOnline

DOWNLOAD EXCEL WORKBOOK

 

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

Fix Column Width in a Pivot Table | MyExcelOnline

 

STEP 2: Uncheck Autofit Column Widths on Update

Fix Column Width in a Pivot Table | MyExcelOnline

 

STEP 3: Update your data

Fix Column Width in a Pivot Table | MyExcelOnline

 

STEP 4: Refresh your pivot table

Fix Column Width in a Pivot Table | MyExcelOnline

Our Pivot Table column widths do not change anymore!

Fix Column Width in a Pivot Table | MyExcelOnline

 

HELPFUL RESOURCE:

728x90

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

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Fix Column Width in a Pivot Table | MyExcelOnline