Arrow Keys

Freebeginner 15 min4 tasks0/54 pts

The arrow keys move one cell. Add Ctrl and they jump to the edge of the data: if you are in a block of data you land on its last cell, and if you are on a gap you land on the next filled cell. Home goes to column A of the current row and PageDown moves down one screen.

Example: Ctrl+→ along a header row lands on the last header. Ctrl+↓ three times can hop across two blocks of data.

Common mistakes

Ctrl+Arrow in an empty sheet runs all the way to the last row or column.
Expecting Ctrl+Arrow to jump past a gap: it stops at the first filled cell after it.

Intro to Shortcuts Cell Selection Shortcuts

Topics/Keyboard Shortcuts and Selection

Arrow Keys

Freebeginner 15 min4 tasks0/54 pts

Example: Ctrl+→ along a header row lands on the last header. Ctrl+↓ three times can hop across two blocks of data.

Common mistakes

Ctrl+Arrow in an empty sheet runs all the way to the last row or column.
Expecting Ctrl+Arrow to jump past a gap: it stops at the first filled cell after it.

Intro to Shortcuts Cell Selection Shortcuts