Forum Discussion
hperrio
Aug 12, 2020Copper Contributor
Help! I've fallen and I can't get out of this cell
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 ...
HansVogelaar
Aug 12, 2020MVP
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.
hperrio
Aug 12, 2020Copper Contributor
HansVogelaar omfg...... my hero!
Thank you so much