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