Viewing formulas in worksheet

T

tonycat

I accidentally managed to change the worksheet to show the formulas in the
cells, and do not know how to go back to normal view. Can anyone help? The
Excel help from the program Help says hit Ctrl + ' or grave symbol. Somehow,
that does not work or else I am not hitting the right key on my laptop's
keyboard. Can anyone help? Thanks!
 
B

Bernard Liengme

The key to use with CTRL is ` and it is to the left of 1 on the top row of
the 'typewriter' keys
Alternatively, use Tools | Options, open the View tab and in the Windows
Options (bottom half) uncheck the Formulas box
best wishes
 

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

Top