Pinterest Pixel

Fix Column Width in a Pivot Table

Each time you Refresh a Pivot Table you will most likely get annoyed at the fact that... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

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 workbookKeep-Column-Width-Upon-Refresh.xlsx

 

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

Fix Column Width in a Pivot Table

 

STEP 2: Uncheck Autofit Column Widths on Update

Fix Column Width in a Pivot Table

 

STEP 3: Update your data

Fix Column Width in a Pivot Table

 

STEP 4: Refresh your pivot table

Fix Column Width in a Pivot Table

Our Pivot Table column widths do not change anymore!

Fix Column Width in a Pivot Table

 

728x90

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

See also  Group Dates with a Pivot Table
Founder & Chief Inspirational Officer at MyExcelOnline.com

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship Academy Online Course.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!