PivotTable and column widths

  • Thread starter Thread starter Peter Aitken
  • Start date Start date
P

Peter Aitken

Am I correct in believing that there is no way to change the column widths
in a PivotTable and have them preserved during updates?
 
Set the pivot table to preserve formatting:
On the pivot toolbar, choose PivotTable>Table Options
Add a check mark to 'Preserve formatting', click OK
Remove the check mark from AutoFormat Table
Click OK
 
Thanks!

Debra Dalgleish said:
Set the pivot table to preserve formatting:
On the pivot toolbar, choose PivotTable>Table Options
Add a check mark to 'Preserve formatting', click OK
Remove the check mark from AutoFormat Table
Click OK
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to add a custom third column on PivotTable? 1
Pivot Table operation is different 1
Difference column in PivotTable 1
Filter PivotTable dropdown items to match report filter 1
PivotTable - Sum and Count 1
GetPivotData 1
PivotTable 3
Linking PivotTable Fields - Excel 2007 1

Back
Top