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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Turn off Autocorrect for Single Document 1
Autonumber field in Excel that behaves the same as Access 0
Word docs emailed to me are opening blank (greyed screen) in Print Mode 0
Newbie Help - IF Yes No Function 0
Remove title bar and phase bar by default on swimlane 0
Display weeks from a Milestone 0
Office Word JPEG in a document showing but not printing out 0
Copy addition formula of non-consecutive horizontal cells 2

Top