2010 Microsoft Excel "Cell has me held prisoner" "You cannot change part of an array

[paynecasey]

So I was casually copy pasting staff from one excel workbook to another. Decided to delete one of them and all the sudden I am held hostage and can not leave this cell. WTF! What do I do?

 

[paynecasey]

Never Mind this worked
https://support.microsoft.com/en-us/kb/107905

 

[C0bra99]

hold down the shift & ctrl and then hit enter, this will allow you to update an array.