Feb 06 2022 04:10 PM
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 problem when I click in the cell. If I have a lot of text in the cell, this is a pain in getting the cursor to the start of the text. Thanks.
Feb 06 2022 10:43 PM
Part 1:
Maybe it's the "Scroll" button?
Accidentally turned on the scroll lock?
Part 2:
Basically, causes can be many, from insufficient RAM to settings in options and cell formatting.
Without knowing a file (without sensitive data), Excel version, operating system and storage medium,
it is difficult to list or guess all possibilities.
In this link you will find some more information about it:
Welcome to your Excel discussion space!
Hope I was able to help you with this info.
I know I don't know anything (Socrates)
Was the answer useful? Mark them as helpful!
This will help all forum participants.
Feb 07 2022 05:25 PM
Oct 12 2023 02:51 PM
Oct 12 2023 03:21 PM - edited Oct 12 2023 03:26 PM
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.