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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies