Selecting frozen cell selects entire column between frozen cell and original selection location

Occasional Visitor

Hi all,

 

Basically what is happening is when my headers are frozen in a sheet (nearly every report/sheet I have), when I go to select the header, it ends up selecting all of the cells between the header and 2 cells below the frozen header line indicator. For example, let's say I'm in cell B108 and trying to select cell B5 (frozen header). When I click on B5, I end up selecting B5:B98 (usually 2 rows below the frozen line, which if i'm scrolled down, can be any number). Every time I select a frozen header line from further down the sheet, it will select the range from the header to 2 rows below the frozen line indicator. Please see the pictures below:

 

Selected B108:

EthanSch734_0-1649724403799.png

 

Selected B5 (frozen header):

EthanSch734_1-1649724441504.png

As you can see, it selected B5:B94, rather than simply B5. Additionally, if I continue to click on B5 after this, it simply scrolls up, as if I'm holding shift and the up arrow key:

 

EthanSch734_2-1649724515311.png

 

Please let me know what I can do to fix this, as I use Excel all day every day for my job and this makes creating some reports very tedious and inefficient. 

 

 

Thanks!

0 Replies