Selecting columns and rows

Single column or row

To select a single column, click on the column header (Figure 1 on Page 6).

To select a single row, click on the row header.

Multiple columns or rows

To select multiple columns or rows that are contiguous:

• Click on the first column or row in the group.

• Hold down the Shift key.

• Click the last column or row in the group.

To select multiple columns or rows that are not contiguous:

• Click on the first column or row in the group.

• Hold down the Ctrl key.

• Click on all of the subsequent columns or rows while holding down the Ctrl key.

Entire sheet

To select the entire sheet, click on the small box between the column headers and the row headers (Figure 12), or use the key combination Ctrl+A to select the entire sheet, or go to Edit on the main menu bar and select Select All.

Figure 12: Select All box