How to lock column width in pivot table?
When you create a pivot table and change the field time and time again, have you noticed that the column width is changed as same time? But if you want to set the column width static in pivot table, do you have any idea to lock the column width of pivot table in Excel?
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
It is easy for you to lock the column width of pivot table after creating your pivot table, please do as this:
1. Click a cell in the pivot table.
2. Then right click, and choose PivotTable Options from the context menu, see screenshot:
3. In the PivotTable Options dialog, under Layout & Format tab, uncheck Autofit column widths on update option, see screenshot:
4. And then click OK, from now, the column width will not be changed with your operations.