O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required