Tuesday, January 17, 2012

How to Fix Column Width in a Pivot Table


1. Launch the 'Microsoft Excel' program and open a spreadsheet in which a pivot table is already created.
2. Right-click the pivot table and choose 'Table Options' from the resulting menu.
3. Uncheck the 'Auto Format Table' box and click 'OK.'
4. Adjust the column widths and refresh the pivot table. The columns will stay fixed at the width you specified instead of reformatting to fit the data.

Blogger news