Home

Formula to text

%3CLINGO-SUB%20id%3D%22lingo-sub-742808%22%20slang%3D%22en-US%22%3EFormula%20to%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-742808%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20entire%20workbook%20turned%20to%20formulas%20and%20I%20don't%20know%20how%20I%20did%20it.%20Now%20I%20need%20to%20undo%20it%20so%20I%20can%20complete%20the%20exercise.%20I%20am%20just%20now%20learning%20how%20to%20use%20the%20program%20and%20am%20very%20lost.%20Any%20held%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-742808%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-742888%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20to%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-742888%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F372791%22%20target%3D%22_blank%22%3E%40beckcvt%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGo%20to%20%3CSTRONG%3EFormulas%3C%2FSTRONG%3E%20tab%20and%20make%20sure%20that%20the%20%3CSTRONG%3EShow%20Formulas%3C%2FSTRONG%3E%20option%20is%20turned%20off.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F122585iD04CAB66EB69F19E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Show%20Formulas.png%22%20title%3D%22Show%20Formulas.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-743420%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20to%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-743420%22%20slang%3D%22en-US%22%3EYou%20may%20also%20press%20Ctrl%2BGraveAccent%2C%20which%20is%20at%20the%20left%20of%201%2C%20below%20the%20Esc%20key.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-743438%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20to%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-743438%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F372791%22%20target%3D%22_blank%22%3E%40beckcvt%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EHere%20is%20a%202%20minutes%20Tutorial%20on%20Finding%2C%20showing%2C%20hiding%20and%20protecting%20formulas%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DGywkmsQSiYA%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DGywkmsQSiYA%3C%2FA%3E%3C%2FP%3E%3CP%3Ehope%20that%20helps%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E
beckcvt
Occasional Visitor

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 ...
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies