I can't select the current region

[Kari22]

Hi guys,
I don't know why I can't select the current region.

My data range is ("B6:D20")
I select the cell "B6" then
I go to "Find and Select" then
I select "Current region"
I press ok
The result of that is that the whole sheet is highlighted

I wonder if anyone know why this is happening?

I'd appreciate the help

 

[Marc L]

Hi !​

​

Select only the cell B6 then apply the keys combo Ctrl A :​

if it's the same result so it's a dumb worksheet with some bad formatting, …​

​

Or just close Excel and any other application. Then retry … (Even reboot the computer)​

 

[Kari22]

Hi !​

​

Select only the cell B6 then apply the keys combo Ctrl A :​

if it's the same result so it's a dumb worksheet with some bad formatting, …​

​

Or just close Excel and any other application. Then retry … (Even reboot the computer)​

Hi Mark,

Yes, I tried the shortcut, but didn't work

I also think it has to do with the formatting but I can't find any information about it

Thanks for taking the time

 

[Marc L]

​

If after closing Excel or even rebooting the computer it's still the same, if anyone else gives you the source of this 'issue'​

then link the workbook on a files host website like Dropbox in order we can see and try to find out the reason why …​