Keeping column width in Excel pivot table?
 

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!

Keeping column width in Excel pivot table?
 

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

Polina wrote:
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!


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html