printing formulas

Roni · May 6th, 2002, 09:33 AM

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 · May 6th, 2002, 09:35 AM

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

Quote:

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 · May 6th, 2002, 09:35 AM

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

Under Window options, check the box next to Formulas

_________________
~*Kristy*~

"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 · May 6th, 2002, 09:40 AM

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

Thanks again!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 6th, 2002, 09:33 AM	#1
Roni Board Regular Join Date: Apr 2002 Posts: 224	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!

May 6th, 2002, 09:35 AM	#3
Von Pookie MrExcel MVP, Administrator Join Date: Feb 2002 Location: The act or process of locating. Posts: 13,679	Or you can go to Tools\|Options\|View tab. Under Window options, check the box next to Formulas _________________ ~Kristy~ "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 ]

May 6th, 2002, 09:40 AM	#4
Roni Board Regular Join Date: Apr 2002 Posts: 224	thank you so much. Both suggestions worked, but I absolutely adore the Ctrl ~ way! Thanks again!