Author: jeepdogjake

How to reset Ctrl-End in Excel

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.