Selecting rows or columns is going weird - please help

Brass Contributor

Hi

 

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!!

 

SGeorgie_0-1671451755863.png

 

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

SGeorgie_0-1671451841743.png

 

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 

 

Thanks

 

 

@Sinagold52 

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