Selecting rows or columns is going weird - please help




Anyone know how to solve this?  Usually when i click a column it goes grey so that i know its selected (same if i click on the row , or SELECT ALL) BUt now its just looks like Column A is highlighted and puts a dotted line around the rest of it!


Sheet Protection is not locked.

No grouping


No idea whats gone wrong!!




Also there is a little square if you try to highlight columns:



3 Replies
Any ideas welcome please
I understand. I think you double clicked the column and that is why there is a dotted line because it means you want to move the whole column I think

this is not the problem


It's like some sort of 'lock' is on. It's not scroll lock