I don’t know about anyone else, but I seem to have this problem a lot. I’ll be editing a worksheet and eliminating rows of data I don’t need, and the Ctrl-End stays at it’s original location. So, I start out with 12k rows, delete 10k, and I expect the Ctrl-End to go to row 2000. Nope, it goes all the way down to row 12,000! If that annoys you as much as it annoys me, here’s the solution:
- Navigate to the last cell in column A with data.
- Move to the next cell down
- Press Ctrl-Shift-End. This will select all the blank cells to the end of the sheet.
- On the Home/Editing menu, click Clear/Clear All.
- Save the file.
That’s it! The Ctrl-End has been reset to the last cell that actually has data.