Cell selection incorrect if document scrolled

nomar116

New Member
Joined
Jan 27, 2020
Messages
16
Office Version
  1. 2013
Platform
  1. Windows
I have workbooks that when opened, will often not select the correct cells by mouse click. For example, I can hover my mouse and click K30, but K5 is selected.

I've noticed that this happens only after scrolling. In fact, if I scroll the document back to its original view when opened, the selection within that view works correctly.

Once the document is scrolled, when I click, the selected cell appears to be the cell that would have been there if the document had never been scrolled.

To recap, if I open the document and do not scroll, select K30 with the mouse, then K30 is highlighted correctly. If I scroll the view down 10 rows, highlight K30 again (which has moved up 10 rows on the screen), then now K20 will be highlighted (even further up the screen).

Any ideas? Usually closing and reopening the program a few times fixes the glitch.
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

nomar116

New Member
Joined
Jan 27, 2020
Messages
16
Office Version
  1. 2013
Platform
  1. Windows
Bump. Very weird glitch, just curious if anyone has seen this before.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,592
Messages
5,573,100
Members
412,502
Latest member
HMilne
Top