How do you print a worksheet that displays the formulas?
 

How do you print a worksheet that displays the formulas rather than the values?

How do you print a worksheet that displays the formulas?
 

Use CTRL+~ and formulas get displayed
You may need to widen columns to see all, so save the file before you start
Now print
Exit without saving and reopen file (saves having to reset all those column
width)


Or see Ron's macro at http://www.rondebruin.nl/print.htm
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"J. Ball" wrote in message
...
How do you print a worksheet that displays the formulas rather than the
values?