In Excel 2007 I have a workbook finished and I want to print the worksheets
with and without the formulas showing.
When I set up the worksheet to print without the formulas and then print all
is well, then when I hit CTRL+` to shoe the formulas, all of the column
widths grow to about triple the original size and then messes up the
printout. Yes I can then re-fit all the columns manually, but then when I go
back to the page without the formulas now it is about 3 times smaller than it
was originally.

What I would like to be able to do/have happen is having the column width
remain the same when I switch back and forth so that the printed page will
look the same without having to re-size each page each time. the formulas are
short and fit in the same space as the values, there is no need for the page
to grow in order to accommodate the display of the formulas so I don't get
why it is doing it and more importantly how do I adjust/prevent the changing
when switching?