How do I stop the cursor from jumping to the bottom of the worksheet?

Select a cell in the middle of some data, and carefully move the mouse cursor so that you align with the top edge of the cell - can you see that the cursor changes shape to show 4 arrows? The same happens if you move the cursor to the bottom edge of the cell, or to the right-hand or left-hand edges of the cell. Now, if you double-click the mouse while you have one of those shapes showing, Excel will move the cursor up (or down, left, or right, depending on which edge you have aligned to) to the end of contiguous data in that direction.

So, I suspect that you double-clicked while the cursor was on the edge of the cell, rather than in the middle of the cell.

Hope this helps.

Pete

Thanks, everyone! I now understand and have control of this feature. I look forward to understanding Tony's cryptic remark. I think "flying leap" is as good a name as any for this feature. And no one suggested an alternative. I'm going to go jump around on my spreadsheet some more...

You can get more information by searching for "Move or Scroll through a worksheet" in Excel Help.

Thanks for the rep, and Happy New Year.

Pete

I think I preferred the other title, Paul.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Pete

Thanks, Pete. I respect the mod's decision to rename the thread, but I am still calling this feature "Flying Leap". If there is a more official name though I would like to know it.

My impression has been that I had this problem mostly with larger spreadsheets and now I understand why. I am exacerbating my problem because, with these larger spreadsheets, I zoom to 60% to get more lines on my screen. This makes it easier to trigger a flying leap by accident. Because the spreadsheet is larger I am likely to leap very far away. And, since there is no way to undo a flying leap, it sometimes is a real chore finding my way back. As a compromise, I have decided to zoom only to 80%. I just wanted to mention zooming in case it benefits anyone else.

Actually now that I have control of the flying leap, it is rather useful. In contrast, I rarely use the fill functionality except during initial setup. The advantage of double clicking is that I can point to the character within the cell that I want to change. Not only is the cell opened for editing, but my cursor is where I want it (or very close). I have taking the "point at the character" somewhat too literally and I will be easily able to start pointing near the vertical center. Trying to point directly at a period or a comma in a 60% zoomed cell seems, in retrospect, to be asking for trouble. It's actually amazing that I perceived the flying leap as rare.

Also I want to point out that I never actually see the cursor change to 4 arrow cursor. So let's say that I have a cell selected in column E but a typo in column B has caught my eye. I move the mouse over to column B and I get the large cross plus sign cursor. I get that plus sign (which is not transparent) positioned over a period and then rapidly double-click. Even at 60% zoom, I wind up with the cell opened for editing with the cursor either before or after the period most of the time. But maybe one time in five I wind up at the bottom of the column. Excel may change the cursor to the 4 arrow cursor between clicks, but it's faster than my eye can follow.

My solution to this is to have the following macro in my person macro workbook:

Please Login or Register  to view this content.

I've assigned it a keyboard shortcut, so I can turn on/off the feature when I need it.

HTH