Select cells

Select cells
	Chapter 2. Cells

Abstract

Select a cell, range of adjacent cells, range of non-adjacent cells, entire worksheet

When a cell or group of cells is selected, actions can be performed on these cells. These operations include deleting the cells, copying them to the clipboard, changing their font and so on.

Select a single cell

To select a single cell, simply click of the cell.

Select a range of adjacent cells

Click on the first cell of the range.
Hold down the left mouse button and drag the cursor to the last cell of the range

Hold down the Shift key and use the direction arrows to move to the last cell of the range.

Hold down the Shift key and click on the last cell of the range.

The selected cells will be highlighted on the worksheet.

Select a range of non-adjacent cells

Hold down Shift and click on the first cell.
Release the Shift key.
Hold down the Ctrl key and click on each of the cells you wish to select.

The following screen shows the selection of a number of non-adjacent cells.

Select an entire worksheet

Edit->Select All (Click on Edit, then click on Select All – see Note on notation above)

Hold down Ctrl and press A.

Select a row, range of adjacent rows, range of non-adjacent rows

Select an entire row

Click on the row number.

Select a range of adjacent rows

Click on the row number of the first of the rows.
Hold down the Shift key and click on the row number of the final row.

Select a range of non-adjacent rows

Click the row number of the first row you wish to select.
Hold down the Ctrl key and click on the row numbers of the other rows you wish to select.

Select a column, range of adjacent columns, range of non-adjacent columns

Select an entire column

Click on the column letter.

Select a range of adjacent columns

Click on the column letter of the first of the columns.
Hold down the Shift key and click on the column letter of the final column.

Select a range of non-adjacent columns

Click the column letter of the first column you wish to select.
Hold down the Ctrl key and click on the column letters of the other columns you wish to select.

The following screen illustrates a number of non-adjacent columns selected.