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.

Welcome to WordPress. This is your first post. Edit or delete it, then start writing!