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.
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
Bump. Very weird glitch, just curious if anyone has seen this before.
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,243
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top