Help! I've fallen and I can't get out of this cell

%3CLINGO-SUB%20id%3D%22lingo-sub-1585265%22%20slang%3D%22en-US%22%3EHelp!%20I've%20fallen%20and%20I%20can't%20get%20out%20of%20this%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1585265%22%20slang%3D%22en-US%22%3E%3CP%3ESo%2C%20I%20don't%20know%20what%20exactly%20an%20%22array%22%20is%2C%20but%20apparently%20I%20have%20managed%20to%20create%20one%20while%20copying%20a%20row%20of%20cells%20from%20one%20workbook%20to%20another.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20pasted%20my%20cells%20normally%20instead%20of%20pasting%20values%2C%20and%20now%20there's%20a%20formula%20present%20in%20the%20first%20pasted%20cell.%20It%20wouldn't%20be%20a%20problem%20except%20I%20accidentally%20clicked%20inside%20of%20the%20cell%20and%20edited%20part%20of%20that%20formula.%20Now%20i'm%20getting%20the%20%22You%20cannot%20change%20part%20of%20an%20array%22%20error.%20My%20cursor%20is%20literally%20trapped%20inside%20the%20cell.%20I%20can't%20even%20exit%20the%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESave%20for%20rebooting%2C%20is%20there%20anything%20I%20can%20do%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1585265%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-1585279%22%20slang%3D%22en-US%22%3ERe%3A%20Help!%20I've%20fallen%20and%20I%20can't%20get%20out%20of%20this%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1585279%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F757668%22%20target%3D%22_blank%22%3E%40hperrio%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPress%20the%20Esc%20(Escape)%20key%20to%20get%20out%20of%20the%20formula.%3C%2FP%3E%0A%3CP%3EThen%20press%20Ctrl%2B%2F%20to%20select%20the%20entire%20range%20that%20the%20array%20formula%20applies%20to.%3C%2FP%3E%0A%3CP%3EYou%20can%20now%20edit%20the%20formula%20or%20clear%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1585289%22%20slang%3D%22en-US%22%3ERe%3A%20Help!%20I've%20fallen%20and%20I%20can't%20get%20out%20of%20this%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1585289%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3Bomfg......%20my%20hero!%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThank%20you%20so%20much%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

So, I don't know what exactly an "array" is, but apparently I have managed to create one while copying a row of cells from one workbook to another. 

 

I pasted my cells normally instead of pasting values, and now there's a formula present in the first pasted cell. It wouldn't be a problem except I accidentally clicked inside of the cell and edited part of that formula. Now i'm getting the "You cannot change part of an array" error. My cursor is literally trapped inside the cell. I can't even exit the sheet.

 

Save for rebooting, is there anything I can do?

2 Replies

@hperrio 

Press the Esc (Escape) key to get out of the formula.

Then press Ctrl+/ to select the entire range that the array formula applies to.

You can now edit the formula or clear it.

@Hans Vogelaar omfg...... my hero!


Thank you so much