Keeping column width in Excel pivot table?

G

Guest

Dear reader,
I'm looking for a way to keep widths of columns in Excel pivot table report
stable whenever I make changes to the table's contents. So far, every time I
pick something different from drop-down lists, my pivot table report
automatically adjusts column widths and I have to format it all over again to
be able to fit into a page for printing purposes, which is very frustrating.
If you know better than this - be sure to let me know!!! :)
Thanks you for help!
 
D

Debra Dalgleish

Right-click a cell in the pivot table, and choose Table Options
Add a check mark to Preserve Formatting
Remove the check mark from AutoFormat table.
Click OK
 

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

Column width of Pivot Table data goes back to default when data refreshed 2
Save new column width settings in pivot table 5
Pivot tables and column widths 1
Retain Column Width 1
Column width format 2
Pivot table column width 2
freeze width of a column used by pivot table 4
Pivot Table: Resulting Column Widths on Drill Down 0

Top