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.
- hperrioAug 12, 2020Copper Contributor
HansVogelaar omfg...... my hero!
Thank you so much