How do I print the spreadsheet and show formulas instead of values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TC - 21 Mar 2008 19:11 GMT

I'm trying to back into a complicated spreadsheet that someone else created,
instead of clicking on every cell, I'd like to just print the spreadsheet
with the formulas showing instead of the value.

HELP!

Reply to this Message

Ron de Bruin - 21 Mar 2008 19:23 GMT

Use the Shortcut to toggle the view

Ctrl + ` (key next to the 1 key)

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

> I'm trying to back into a complicated spreadsheet that someone else created,
> instead of clicking on every cell, I'd like to just print the spreadsheet
> with the formulas showing instead of the value.
>
> HELP!

Reply to this Message

Per Jessen - 21 Mar 2008 19:23 GMT

Hi

In Excel 2000:

Tools > Options > View > In the "Window options" part click on Formulas > OK

This will show and print formulas.

Regards,

Per

> I'm trying to back into a complicated spreadsheet that someone else
> created,
> instead of clicking on every cell, I'd like to just print the spreadsheet
> with the formulas showing instead of the value.
>
> HELP!

Reply to this Message