software

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!

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:
gt; Dear reader,
gt; I'm looking for a way to keep widths of columns in Excel pivot table report
gt; stable whenever I make changes to the table's contents. So far, every time I
gt; pick something different from drop-down lists, my pivot table report
gt; automatically adjusts column widths and I have to format it all over again to
gt; be able to fit into a page for printing purposes, which is very frustrating.
gt; If you know better than this - be sure to let me know!!!
gt; Thanks you for help!--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html