How do stop Excel changing column widths when doing pivots?

When I am doing multiple pivots I have to keep resizing the columns as Excel
resizes them, can autofit be turned off?

Right-click anywhere inside the pivot table. Select 'Table Options...'.
Unclick 'AutoFormat Table' and select OK.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"CB" wrote:

> When I am doing multiple pivots I have to keep resizing the columns as Excel
> resizes them, can autofit be turned off?