Formula to text

Copper Contributor

My entire workbook turned to formulas and I don't know how I did it. Now I need to undo it so I can complete the exercise. I am just now learning how to use the program and am very lost. Any held appreciated.

3 Replies

@beckcvt

 

Hi,

 

Go to Formulas tab and make sure that the Show Formulas option is turned off.

Show Formulas.png

 

 

You may also press Ctrl+GraveAccent, which is at the left of 1, below the Esc key.

@beckcvt 

Hi,

Here is a 2 minutes Tutorial on Finding, showing, hiding and protecting formulas

https://www.youtube.com/watch?v=GywkmsQSiYA

hope that helps

Nabil Mourad

This is a Bite-Size Excel Tutorial Series (less than 3 minutes) targeting anyone on the globe using Excel since I broke the barrier of language and I explain the topic fully in graphics. We spend a long time creating and auditing our Formulas & Functions, which sometimes could be complicated and ...