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

2 comments

  1. actually, I am shocked how many people do not know these basics. VBA code is very useful for detecting data blocks.

Leave a Reply

Your email address will not be published.