Archive of Mr Excel Message Board

Back to Pivot Tables in Excel archive index
Back to archive home

Fixed columns width no matter what pivot table data comes in

Posted by Nona Sloven on April 26, 2001 11:46 AM

Hi.

I have a pivot table in Excel’97. I have seen that it is an annoyance when you change data in a pivot table and Excel causes the column widths to change too. This same nuisance occurs when you refresh the pivot table. This ends up embarrassing all of your formating causing a mess. Is there a way to tell Excel not to change column widths when data suffers width variations or when you refresh your pivot table? Is there is a way, please help. Your assistance will be appreciated.

Re: Fixed columns width no matter what pivot table data comes in

Posted by Mark W. on April 26, 2001 12:15 PM

Nona, apply a number format to the DATA area of your
PivotTable that pads the numeric value with a sufficient
number of leading spaces.

You can get even better results...

Posted by Mark W. on April 26, 2001 12:31 PM

...if you format the PivotTable ROW and/or COLUMN
labels using @" " as a format. Of course,
you'll want to adjust the length of the string of
spaces to get the desired fixed column width.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.