Navigation through Excel sheet – End Of Data

Quickly move to the end or beginning of big chunks of data.

Magic shortcut is Ctrl + <arrow_key>

Ctrl + Up – Moves cursor up until empty cell

Ctrl + Down – Moves cursor down until empty cell

Ctrl + Left – Moves cursor left until empty cell

Ctrl + Right – Moves cursor right until empty cell

When holding Ctrl + Shift + <array keys> it moves cursor and extends the selection area. Very practical example to select rectangular data within TWO strokes:

  1. While holding “Ctrl + Shift”  push “Left”
  2. While still holding “Ctrl + Shift”  push “Down”

Date data end within VBA code

The same keyboard trick is available from VBA code

Sheets("Sheet1").Cells(1, 1).End(xlToRight)
Sheets("Sheet1").Cells(1, 1).End(xlDown)
Sheets("Sheet1").Cells(1, 1).End(xlToLeft)
Sheets("Sheet1").Cells(1, 1).End(xlUp)
Did you find this post useful? Support the the author ($10)
My Google Profile+


Leave a Reply

Your email address will not be published.