Larger Cell Selections

Freebeginner 15 min4 tasks0/54 pts

Holding Shift while you move extends the selection instead of moving it. Shift+Arrow grows it one cell at a time, Ctrl+Shift+Arrow grows it to the edge of the data, and Shift+Click selects everything between two cells.

Example: From C2, Ctrl+Shift+↓ selects the whole Sales column down to the last row of data.

Common mistakes

Starting the selection from the header, so the header ends up included.
Releasing Shift too early: the selection then just moves.

Cell Selection Shortcuts Row and Column Selections