Forum Discussion

Copper Contributor

Feb 07, 2022

Cursor in Edit mode

When I'm in Edit mode, my cursor doesn't move to where I click in the Edit box - it only stays at the end of the text. Did anyone experience this and how did you resolve it? I also have the same prob...

excel

Buddy_S

Copper Contributor

Feb 08, 2022

Thanks. I just noticed this problem a couple days ago. I was working on a file that I've had for years so it shouldn't be the file, OS, RAM, or Excel version. I tried a different mouse with the same results. The issue seems to go away when I use the mouse to scroll to the top of the sheet (I can edit in the cell or formula bar with the cursor positioned at the location that I clicked). If I use the mouse to scroll down the page, then the issue appears (I cannot edit in the cell or formula bar and the cursor is positioned at the end of the cell contents). Again, I tried a different mouse with the same result. Thanks for the suggestions though.

Larry_Walsh

Copper Contributor

Oct 12, 2023

This is the exact same situation I have, too - I can't use the mouse to put the cursor in a specific bit of text in a cell, but I CAN do so if I have the sheet scrolled to the top. I tried two different keyboards, two different mice, had no impact.
The weird thing is the problem is not consistent - as in for cells where I'm not scrolled to the top, I can sometimes edit them as I want, sometimes I can't. No idea why.
I've tried turning scroll lock on and off, made no difference.

Larry_Walsh
Copper Contributor
Oct 12, 2023
Ok, this is.... stupid. Makes no sense, but here's what's happening, in my case at least:

For me, the problem has been intermittent. I've been trying to figure out why, so I selected one sheet that had a ton of data on it. I made a copy of the sheet and started tinkering. I selected one cell to focus on (kept testing there to see when I can/can't edit), I tried changing fonts in various places on the sheet, fill colors, deleting big chunks of data, deleting rows, columns, etc, scrolling up and down, etc to try to see when I was allowed to edit that cell vs. when I wasn't.
The answer is stupid.
I had some cells on that sheet that had borders turned on. I got rid of the borders, I could edit every cell in every condition, whether I was scrolled to the top or not. I put the borders back, the bug comes back. I've tried this a number of times, it's consistent - bug's there when borders are present, leaves when the borders are gone.

Borders.
Why.

I've been using excel for over 20 years, I've never encountered this issue; I've even got some very similar sheets at home, I use the same type of formatting everywhere - doesn't happen on my home computer, just here at work.