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)

Tweet