Save incomplete formula

%3CLINGO-SUB%20id%3D%22lingo-sub-3190216%22%20slang%3D%22en-US%22%3ESave%20incomplete%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3190216%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20save%20a%20cell%20with%20an%20incomplete%20formula%20to%20edit%20later%3F%3CBR%20%2F%3ERight%20now%20if%20I'm%20entering%20a%20long%20formula%20but%20it%20has%20a%20typo%20excel%20will%20terrorize%20me%20with%20error%20messages(including%20sound!)%20until%20the%20end%20of%20time%20or%20will%20delete%20the%20entire%20formula%20when%20I%20hit%20escape.%20No%20editor%20should%20delete%20things%20without%20user%20permission.%20Is%20there%20a%20way%20to%20turn%20off%20this%20annoying%20%22feature%22%3F%3CBR%20%2F%3EOne%20work%20around%20I%20could%20think%20of%20was%20to%20at%20a%20single%20quote%20at%20the%20beginning%20of%20the%20cell%20to%20convert%20it%20to%20a%20string.%20But%20that%20is%20such%20a%20hassle.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3190216%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-3190238%22%20slang%3D%22en-US%22%3ERe%3A%20Save%20incomplete%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3190238%22%20slang%3D%22en-US%22%3EA%20space%20before%20the%20equal%20sign%20can%20%22freeze%22%20the%20formula%20for%20you%20to%20edit%20later.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3190244%22%20slang%3D%22en-US%22%3ERe%3A%20Save%20incomplete%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3190244%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1312937%22%20target%3D%22_blank%22%3E%40John_Bloggs655%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EDo%20you%20want%20to%20communicate%20the%20formula%20you%20have%20so%20far%3F%20Maybe%20someone%20can%20complete%20the%20formula%20for%20you.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

How do I save a cell with an incomplete formula to edit later?
Right now if I'm entering a long formula but it has a typo excel will terrorize me with error messages(including sound!) until the end of time or will delete the entire formula when I hit escape. No editor should delete things without user permission. Is there a way to turn off this annoying "feature"?
One work around I could think of was to at a single quote at the beginning of the cell to convert it to a string. But that is such a hassle.

3 Replies
A space before the equal sign can "freeze" the formula for you to edit later.

@John_Bloggs655 

Do you want to communicate the formula you have so far? Maybe someone can complete the formula for you.

Remove the equal sign (=) will help too