excel not selecting the right cell problem

Question

It keeps selecting the wrong cell and row

Answer 1

Hello,

I am encountering this same issue. Yesterday morning, I had no issues with it. Since yesterday afternoon, I haven't been able to select the cell I click on, unless at 100% zoom. Any solutions? Thanks!

Answer 2

We are having the same issues with multiple users reporting this. works fine by going to 100% zoom but it is not scalable for some excel worksheet and need to be used at 50% or 80% and when moving to 50% or 80%, it starts selecting wrong cell when you click on something.

Answer 3

Hi,

We are also experiencing this exact issue when accessing excel documents in the web app (Edge 128.0.2739.42)

Answer 4

Hi!

Since today, I have the same problem when using the web app (browser: Edge).

The selection is offset vertically from where I click, when I'm not at 100 % display. I've tested several files, including an empty workbook, and there's always the same problem. Everything seems to work normally via the desktop application.

Example:

• Zoomed-out at 70% - if I click on cell A1, it selects A8.
• Zoomed-in at 130% - if I click cell A8, it selects A5.

The interface buttons work normally, the offset being only on the workbook content (columns, rows, but also headers).

This is the first time this has happened to me, and a colleague mentioned today that he had the same problem. So I'm even wondering if the problem is widespread (or maybe through our organization).

Thanks for your help!

Answer 5

Dear EJIOGU Didi,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

I’m sorry you’re having a problem but based on your description we can work together to resolve it.

For the situation you encountered, we deeply understand the inconvenience caused and apologize for it.

As per your description, firstly, may I know does issue happened to specific Excel document file? also, may I know have you tried You can open your Excel file in safe mode to check whether it related to add-ins.

May I know, does the formula bar not showing in your Excel sheet? the Ita setting issue(File/Options/Advanced/Display/Check show formula bar).

Also, could you please confirm does this file have macros?

In the meantime, to confirm whether this is a bug in a specific version, please provide us the version information. To check version: Open any Office e.g., Word>File>Account>Product Information and capture a full screenshot and share here (Please mask your private message for protecting your private message) and we will be tested on that version and verify the result with you.

Once again, I apologize for the inconvenience this has caused. We appreciate your patience and understanding and thank you for your time and cooperation.

Sincerely,

Ralph Chawatama | Microsoft Community Moderator