Hi,

I get this every few years can keep forgetting how to get out of it but I have a spreadsheet where the one cell remains highlighted and is locked to that cell, so even if I select another cell it stays locked to it - any ideas?

Cheers

Sounds like the sheet is protected and the one cell you describe is the only one that is unlocked.

Try going to Tool protection > unprotect sheet