A single cell

Click the cell, or press the arrow keys to move to the cell

A range of cells

Click the first row heading in the range, and drag down or hold down SHIFT while you click the last row heading, or hold down SHIFT while you press the arrow keys to extend the selection.

Pressing CTRL+SHIFT+ARROW keys expands the selection stepwise in the WBS.

Multiple range selection for the Name Manager: hold down CTRL.

A large range of cells

Click the first cell in the range, and then hold down SHIFT while you click the last cell in the range. You can scroll to make the last cell visible.

Pressing CTRL+SHIFT+ARROW keys (→ ← or ↑) expands the selection all at once in the Minutes view.

All cells on a worksheet

Click the Select All cell which is at the intersection of the columns-headings and row-headings. Alternative for the Minutes view and Nomenclatures, select the second row.

The first or last cell in a row or column

Select a cell in the row or column, and then press CTRL+ARROW keys (→ or ← for rows, ↑ or ↓ for columns). In the Minutes view, it works only for the rows.

The first or last cell on a worksheet

Press CTRL+HOME to select the first cell on the worksheet.

Press CTRL+END to select the last cell on the worksheet.

Cells to the last used cell on the worksheet (lower-right corner)

Select the first cell, then press CTRL+SHIFT+END to extend the selection of cells to the last used cell on the worksheet (lower-right corner)

Cells to the beginning of the worksheet

Select the first cell, then press CTRL+SHIFT+HOME to extend the selection of cells to the beginning of the worksheet

More or fewer cells than the active selection

Hold down SHIFT while you click the last cell that you want to include in the new selection. The rectangular range between the active cell and the cell that you click becomes the new selection

An entire row or column

Click the row or column heading (or reference header: you may need to switch to the Edit mode).

You can also select cells in a row or column by selecting the first cell and then pressing CTRL+SHIFT+ARROW key (→ or ← for rows, ↑ or ↓ for columns); ↓ does not work in the Minutes view

If the row or column contains data, CTRL+SHIFT+ARROW keys select the row or column to the last used cell.

Adjacent rows or columns

Drag across the row or column headings. Or select the first row or column; then hold down SHIFT while you select the last row or column. In the Minutes view, the rows must sit in the same section.

NON Adjacent rows or columns

Select the first row or column; then hold down CTRL while you select the last row or column. This does NOT apply to rows in the Minutes & Nomenclatures views

All rows above or below

Select a row, then press CTRL+SHIFT+↑ or ↓. In the Minutes view, it is limited to the current section of minutes