To work with a cell, you must select it, and thereby make it active.
To select a cell:
Move your cursor to the cell you want to select.
Click the left mouse button.
The cell will be selected, and thus, active. A heavy border will appear around the cell.
Selecting Cell Ranges
You can select more than one cell at a time. To select a range (i.e., block) of cells:
Move your cursor to the first cell you want to select.
Click, and hold down, the left mouse button.
Without releasing the mouse button, move your cursor the last cell of the range you want to select. The cells you have selected will be highlighted and surrounded by a heavy border.
Release the mouse button.
Example:
Perhaps you want to select the cells from C5 to E10.
Put your cursor inside C5.
Click (and hold down) the left mouse button.
Without letting go of the left mouse button, move the cursor down to E10. All the cells from C5 to E10 will be selected and surrounded by a heavy border
Release the mouse button.
Note that the range of the cells from C5 to E10 can be written as C5:E10.
Selecting Different Cells
When you select a cell range, the cells must be in the same rows or columns. You can, however, select multiple cells that are not in the same rows and columns.
To select multiple cells:
Left-click on the first cell you want to select.
Hold down the Ctrl key while you click the other cells (or cell ranges) that you want to select.
Selecting All Cells
To select all the cells in your current spreadsheet:
Press Ctrl+A on your keyboard. Or,
Click the blank button at the top-left corner of your sheet (between the A and 1).
De-selecting Cells
To de-select a group of cells, simply click the mouse anywhere within your sheet.
See Also: