HELP! stuck excel cell formula I cant get rid of

%3CLINGO-SUB%20id%3D%22lingo-sub-2333647%22%20slang%3D%22en-US%22%3EHELP!%20stuck%20excel%20cell%20formula%20I%20cant%20get%20rid%20of%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2333647%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20-%20I'm%20no%20excel%20guru%20-%20was%20doing%20a%20cut%2Fpaste%20of%20a%20few%20hundred%20rows%20of%20data%2C%20and%20somehow%20hit%20a%20wrong%20key(s)%2C%20and%20now%20can't%20get%20rid%20of%20this%20weird%20formula%20I%20inadvertently%20created%2C%20which%20has%20my%20spreadsheet%20locked%20up.%20Hitting%20delete%20or%20backspace%20does%20nothing.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20formula%20at%20the%20top%20of%20my%20excel%20spreadsheet%20displays%20this%3A%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%3D421%3AG6562.45%26nbsp%3B%3C%2FP%3E%3CP%3E421%20is%20the%20very%20top%20row%20in%20the%20section%20I%20was%20highlighting%2C%3C%2FP%3E%3CP%3Eand%20G656%20was%20the%20very%20first%20cell%20I%20started%20to%20highlight.%3C%2FP%3E%3CP%3E52.45%20is%20the%20value%20in%20that%20cell%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20someone%20can%20provide%20so%20that%20I%20can%20get%20back%20to%20my%20project%20is%20SINCERELY%20appreciated.%3C%2FP%3E%3CP%3ETHANK%20YOU%20in%20advance!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETom%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2333647%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2335526%22%20slang%3D%22en-US%22%3ERe%3A%20HELP!%20stuck%20excel%20cell%20formula%20I%20cant%20get%20rid%20of%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2335526%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1047456%22%20target%3D%22_blank%22%3E%40tmlmyusername%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECould%20you%20attach%20a%20copy%20of%20the%20workbook%2C%20without%20sensitive%20data%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2335664%22%20slang%3D%22en-US%22%3ERe%3A%20HELP!%20stuck%20excel%20cell%20formula%20I%20cant%20get%20rid%20of%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2335664%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Hans%20Vogelaar%2C%20thank%20you%20for%20reaching%20out.%20There%20is%20no%20sensitive%20data%20in%20the%20spreadsheet%2C%20so%20I%20hope%20these%20screenshots%20will%20suffice.%20First%20image%20is%20from%20the%20spreadsheet%20I%20was%20working%20on%20when%20things%20locked%20up.%20Second%20image%20shows%20the%20different%20circular%20reference%20in%20the%20formula%20bar%20of%20the%202nd%20spreadsheet%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22tmlmyusername_1-1620399501217.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F279100i1E3972490BC471A2%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22tmlmyusername_1-1620399501217.png%22%20alt%3D%22tmlmyusername_1-1620399501217.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22tmlmyusername_4-1620399778970.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F279103i026F27D42B8A8A3C%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22tmlmyusername_4-1620399778970.png%22%20alt%3D%22tmlmyusername_4-1620399778970.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%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2335698%22%20slang%3D%22en-US%22%3ERe%3A%20HELP!%20stuck%20excel%20cell%20formula%20I%20cant%20get%20rid%20of%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2335698%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1047456%22%20target%3D%22_blank%22%3E%40tmlmyusername%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI'm%20afraid%20a%20screenshot%20doesn't%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2335725%22%20slang%3D%22en-US%22%3ERe%3A%20HELP!%20stuck%20excel%20cell%20formula%20I%20cant%20get%20rid%20of%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2335725%22%20slang%3D%22en-US%22%3EApologize%20if%20the%20image%20quality%20is%20fuzzy.%20To%20your%20request%20of%20sending%20a%20copy%20of%20the%20file%20-%20I%20am%20unable%20to%20do%20anything%20with%20either%20file.%20Almost%20all%20functions%20are%20disabled%2C%20including%20copy%2Fpaste.%20I%20can't%20even%20open%20another%20new%20excel%20spreadsheet.%20When%20I%20try%20to%20do%20any%20of%20these%20things%20I%20get%20%22There%20is%20a%20problem%20with%20this%20formula%22%20error%20message.%20I've%20tried%20putting%20an%20apostrophe%20in%20front%20of%20the%20formula%20as%20suggested%20to%20try%20%26amp%3B%20fix%20the%20formula%2C%20but%20that's%20as%20far%20as%20I%20can%20get.%20And%20I%20wasn't%20trying%20to%20create%20a%20formula%20at%20all.%20Just%20ended%20up%20with%20me%20mistakenly%20hitting%201%20or%20more%20keys%20on%20the%20keyboard%20when%20I%20was%20trying%20to%20cut%2Fpaste%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi - I'm no excel guru - was doing a cut/paste of a few hundred rows of data, and somehow hit a wrong key(s), and now can't get rid of this weird formula I inadvertently created, which has my spreadsheet locked up. Hitting delete or backspace does nothing.

 

The formula at the top of my excel spreadsheet displays this:  

=421:G6562.45 

421 is the very top row in the section I was highlighting,

and G656 was the very first cell I started to highlight.

52.45 is the value in that cell

 

Any help someone can provide so that I can get back to my project is SINCERELY appreciated.

THANK YOU in advance!

 

Tom

9 Replies

@tmlmyusername 

Could you attach a copy of the workbook, without sensitive data?

Hi Hans Vogelaar, thank you for reaching out. There is no sensitive data in the spreadsheet, so I hope these screenshots will suffice. First image is from the spreadsheet I was working on when things locked up. Second image shows the different circular reference in the formula bar of the 2nd spreadsheet

 

tmlmyusername_1-1620399501217.png

tmlmyusername_4-1620399778970.png

 

 

 

@tmlmyusername 

I'm afraid a screenshot doesn't help.

Apologize if the image quality is fuzzy. To your request of sending a copy of the file - I am unable to do anything with either file. Almost all functions are disabled, including copy/paste. I can't even open another new excel spreadsheet. When I try to do any of these things I get "There is a problem with this formula" error message. I've tried putting an apostrophe in front of the formula as suggested to try & fix the formula, but that's as far as I can get. And I wasn't trying to create a formula at all. Just ended up with me mistakenly hitting 1 or more keys on the keyboard when I was trying to cut/paste
Pretty much the only function available is scrolling up or down in the files. Any suggestions?
Under Formula's tab, it appears I now have everything but "Calculations" features available
Scratch that - just the "Function Library" features are available
I have no ability to open "File" tab at all - that's when I get that previously noted Excel error message

@tmlmyusername 

If you cannot attach the workbook there is nothing I can do for you. Sorry!