Pivot Tables Resizing Columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working with pivot tables. When I introduce another variable into the pivot table or run a show pages to create individual reports based on a field, it seems to change all the fonts and resize all of the columns and the like. Is there any way to lock this down so that the columns and formats are the same for all pages in the workbook

Any help would be most appreciated.
 
Rightclick the table & choose "Table Options" from the pop-up menu.

Uncheck "AutoFormat Table".

HTH,
Andy
 
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

Excel VBA For excel 0
Pivot table grand total location 1
pivot table data 2
Pivot Table won't Get 'r done 1
Referencing a pivot tables Grand Totals Column 1
Pivot table column widths 1
Pivot Table - Changes 5
Error on text wrap pivot table 1

Back
Top