Excel Extends Selected Cells Up When Using Shift-PageDown -- Selects from Active Cell to Top Row (Wrong Direction)

Question

Periodically and for months, if not more than a year, Excel has exhibited a frustrating behavior when extending a selection. 

If I am on a cell, and I hold the shift key while paging down, the visible rows increase, but the selection goes from the cell I'm in to the top. So although the screen pages down, the selection goes from the current cell up all the way to the first row -- it moves in the opposite (and wrong) direction.

This will happen in one sheet that is open but not necessarily in others. It appears unconnected to frozen rows or columns. Scroll Lock is not engaged. It is typically "fixed" by closing the problem workbook and reopening it. It happens in different sheets at different times, some of which are fairly large and others which are not.

Below are screen grabs demonstrating the behaviour.

Before doing anything.

After pressing Shift-PageDown once.

After, scrolling to the top (but not pressing any keys) -- this shows that even though the visible rows increased, the active cell remains BA4 with the range BA1:BA4 selected.

Any ideas what is going on? I feel it is an Excel bug that's been rearing its head from time to time for a year or more.

This occurs on multiple Windows 10 machines with fully updated systems and Office 365.

Answer 1

This started happening to me about a month ago with Office 365.  It is very annoying.  I think an Office repair temporarily fixes the issue, but it will soon start happening again.  It only happens for me on sheets with frozen panes, but it's not on all sheets or workbooks.