printing formulas

[Roni]

Is there a way to print an Excel spreadsheet and have it print the FORMULAS in each cell as opposed to the values?

Thanks for any help offered!

 

[minnie]

Ctrl + ~ (tilde right below Esc key) will show you formulas and you can print them.

On 2002-05-06 08:33, Roni wrote:
Is there a way to print an Excel spreadsheet and have it print the FORMULAS in each cell as opposed to the values?

Thanks for any help offered!

 

[Von Pookie]

Or you can go to Tools|Options|View tab.

Under Window options, check the box next to Formulas

_________________<font color=red>~*</font><font color=blue>Kristy</font><font color=red>*~</font>

"Catapultam habeo. Nisi pecuniam omnem mihi dabis, ad caput tuum saxum immane mittam."

This message was edited by Von Pookie on 2002-05-06 08:36

 

[Roni]

thank you so much. Both suggestions worked, but I absolutely adore the Ctrl ~ way!

Thanks again!