Windows Keyboard Shortcut of the Day

End, Arrow Key: Move by sections in Excel

Posted in Microsoft Excel by estephen on April 10th, 2007

Excel has a strange navigation key that’s fairly unique and takes a bit of getting used to, but once you start using it, you’ll wonder how you ever used Excel without it.

Load up an Excel spreadsheet for practice, and then position your cursor somewhere in the middle of some cell entries. (Remember you can use the F5 key to go to a location.)

Now press End then the Right Arrow key (one after the other). You’ll go to the rightmost entry in the column of cell entries. Hit End, Down Arrow. You’ll move down until you hit the next empty cell.

If you start in an empty cell, Excel will keep moving in the direction of the arrow key you press until it hits a non-blank cell.

2 Responses to 'End, Arrow Key: Move by sections in Excel'

Subscribe to comments with RSS or TrackBack to 'End, Arrow Key: Move by sections in Excel'.

  1. Mark said,

    on April 12th, 2007 at 5:26 am

    I generally use CTRL+Arrow to accomplish this. I didn’t know about the End, Arrow method, but I think I prefer and will continue to use the CTRL+Arrow method. Seems a little easier. FWIW, HTH!

  2. estephen said,

    on April 12th, 2007 at 9:04 am

    Interesting! For some reason I always thought Ctrl+Arrows in Excel moved by screen (perhaps it did work that way in an old version), which isn’t as useful. So I never used them. But you’re right, Ctrl+Arrows does the same thing as End movement, and I agree that’s easier.

    However, you can use End, Enter to move to the far right of the current row, which is pretty useful.

Leave a Reply