If you double click on (or really near) the border of the cell, the selected cell jumps to the first empty cell to the left in the same row (if it was a side border) or up in the same column (if it was a top/bottom border).
One source argued that unfortunately, the cells are often large with lots of text. Scrolling is very difficult, because the cell is often clipped by the screen edges, and when you try to scroll, it jumps to the next cell, so you can never see the full cell contents.
Some sources claimed we have Data in Cells A1:A100. At this point the vertical Scroll Bar goes from row 1 to row 100. Now someone decides to put something non trivial (something that includes some formatting like a date or currency) into cell A200. And it’s not a shock that at this point, the vertical Scroll Bar goes all the way to row 200.
You should be asking “How to make scrolling in Excel more smooth?”
Chosing Excel because of the controlled cells for text. My solution was to keep the heights of the cells in the sheet, thus scrolling floats smoothly. The cells with text were made by merging many cells.
How to enter cells instead of double clicking?
Previous workarounds have generally been based on using F2 to enter cells instead of double-clicking. The reason I’m not doing this right now is because my task involves copying/moving parts of the text in one cell to another cell, and my workflow is as follows: 1) Double click on source cell.
Another inquiry we ran across in our research was “How do I move text from one cell to another cell?”.
1) Double click on source cell. (The cell could be anywhere so I need to use the mouse for this.) 2) Highlight text to move with mouse. 4) Double-click on destination cell. (Again, could be anywhere.) 5) Click on position to insert new text within existing cell text.
You can disable it by Tools> Options> Edit. Uncheck “allow cell drag and drop”. A great disadvantage. I would suggest you don’t d-click on any cell borders. > > Are you perhaps d-clicking on the bottom or top border of the cell?
Why is my screen scrolling uncontrollably?
Replacing the battery alone does not seem to fix it, nor does rebooting/etc. Only once you’ve replace the battery and reinserted the dongle will the uncontrollable scrolling resolve. This issue is rare enough that it’s incredibly difficult to find an answer online.