Selecting rows or columns is going weird - please help

Brass Contributor



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:



4 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 






Yes, I have the same problem - since I bought Office 2021.@SGeorgie . It DOES select the row/column, though. When you shift sideways/up/down to select more rows/columns and then back to only one row/column , it goes grey after all. Annoying, yes