Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing a worksheet with and without formulas showing
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I paste an excel worksheet in Word showing formulas? | Excel Discussion (Misc queries) | |||
Printing without formulas showing | Excel Discussion (Misc queries) | |||
printing without zeros showing in a cell with formulas | Excel Worksheet Functions | |||
Formulas showing on worksheet | Excel Discussion (Misc queries) | |||
How can I print my excel worksheet showing formulas in the cells? | Excel Worksheet Functions |