Extend a Selection
Press | To |
|---|---|
F8 | Turn on or off extend mode. In extend mode, EXT appears in the status line, and the Arrow keys extend the selection. |
Shift+F8 | Add another range of cells to the selection, or use the arrow keys to move to the start of the range you want to add, and then press F8 and the Arrow keys to select the next range. |
Shift+Arrow | key Extend the selection by one cell. |
Ctrl+Shift+Arrow | key Extend the selection to the last nonblank cell in the same column or row as the active cell. |
Shift+Home | Extend the selection to the beginning of the row. |
Ctrl+Shift+Home | Extend the selection to the beginning of the worksheet. |
Ctrl+Shift+End | Extend the selection to the last used cell on the worksheet (lower-right corner). |
Shift+Page | Down Extend the selection down ... |
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access