Selecting rows or columns is going weird - please help

[SGeorgie]

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

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

[#2]

Any ideas welcome please

[#3]

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

[#4]

this is not the problem

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

Thanks

@Sinagold52 

[#5]

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