Subscribe (via Feedburner)
End, Arrow Key: Move by sections in Excel
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.
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!
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.
on June 24th, 2009 at 7:11 am
In earlier versions of Excel, copying cells in columns to the right of data used to be easy. You simply hightlited the cell to copy and then moved cursor over to the column with data that you wanted to copy next to. This option doesn’t seem to work in 2007, unless of course someone knows how to accomplish this. If so, please help. thanks