1.5 Select to the end in one move

Select every amount in column B, from B2 down to the last one in row 21, without the mouse. You start on B2.

Ctrl+Shift+↓ stretches the selection to the last filled cell before a gap. If it stops early, press it again.

01 Select to the end in one move Ctrl + Shift + arrow Core

Click a cell while typing to insert it, drag to select a range, F4 adds $, Esc cancels.

Tap a cell while writing a formula to insert it, or slide across cells for a range. The strip above the keyboard has = ( ) : , $.