Turn off formulas

[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.

 

[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.

 

[JulieD]

glad to help & thanks for the feedback

That was too easy..thank you for your prompt response.


values

 

[HT]

That was too easy..thank you for your prompt response.

 

[Gord Dibben]

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

Gord Dibben Excel MVP

 

[HT]

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

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

Gord Dibben Excel MVP