Excel tools to demonstrate

Using End-Arrow Key Combinations

To go to the end of a range (top, bottom, left, or right):

Press the End key, then the appropriate arrow key. For example, press End and then right arrow to go to the right edge of a range.

Try it! Starting at a corner (a bordered cell), move around to the other corners.

The action of an End-arrow combination depends on where you start. It takes you to the last nonblank cell if you start in a nonblank cell. (If there aren’t any nonblank cells in that direction, it takes you to the far edge of the sheet.) If you start in a blank cell, it takes you to the first nonblank cell.