Turn off formulas

H

HT

I don't want any formulas to show in a document..I just want the values to
show.

How can I do this?

Thank you.
 
J

JulieD

If you're saying that you see in a cell =A1+B1 rather than the result of the
formula choose Tools / Options / View and untick formulas.
 
G

Gord Dibben

Even easier is CRTL + `(back quote above TAB key) to toggle formula view
on/off.

Gord Dibben Excel MVP
 
H

HT

Oh my..this is getting easier..thanks all!

Gord Dibben said:
Even easier is CRTL + `(back quote above TAB key) to toggle formula view
on/off.

Gord Dibben Excel MVP
 
Top