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 ...

Get Microsoft® Office Excel 2003 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.