How do stop Excel changing column widths when doing pivots?

C

CB

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

Gary L Brown

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

HTH,
 
Top