How do you print a worksheet that displays the formulas rather than the values?
J J. Ball Feb 9, 2009 #1 How do you print a worksheet that displays the formulas rather than the values?
B Bernard Liengme Feb 9, 2009 #2 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
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
