Can I have the formulas instead of computation on the screen.

[Guest]

I want to see the formula instead of the result of the computation in each
cell when I print.

 

[Niek Otten]

Tools>Options>View tab, check Formulas

You can also toggle this with a shortcut:

CTRL+`

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I want to see the formula instead of the result of the computation in each
| cell when I print.

 

[Gord Dibben]

In addition to Niek's post, if you want you can print the formulas, values and
addresses on a separate sheet if you wished.

Code at John Walkenbach's site.

http://www.j-walk.com/ss/excel/tips/tip37.htm


Gord Dibben MS Excel MVP

On Wed, 21 Nov 2007 12:04:01 -0800, Printing formulas <Printing

 

[Niek Otten]

Thanks for a useful addition, Gord!

Sometimes it' better to spend an additional "few seconds" to think about what the OP is trying to do


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Gord Dibben" <gorddibbATshawDOTca> wrote in message | In addition to Niek's post, if you want you can print the formulas, values and
| addresses on a separate sheet if you wished.
|
| Code at John Walkenbach's site.
|
| http://www.j-walk.com/ss/excel/tips/tip37.htm
|
|
| Gord Dibben MS Excel MVP
|
| On Wed, 21 Nov 2007 12:04:01 -0800, Printing formulas <Printing
| (e-mail address removed)> wrote:
|
| >I want to see the formula instead of the result of the computation in each
| >cell when I print.
|