In a worksheet, you can select cells, ranges, rows, or columns. This is an important skill which allows you to, for example, apply the same formatting change to all of the selected cells. You can also select all or part of the cell contents and turn on Editing mode to modify the data within a cell.

#1)
Selecting a single cell:
Here we simply clicked on cell C7. We can also just use the arrow keys to make the same selection.
#2)
Selecting a range of cells:
Click the first cell in the range, and then drag to the last cell, or hold down SHIFT while you press the arrow keys to extend the selection.
Note:
You can also select the first cell in the range, and then press F8 to extend the selection by using the arrow keys. To stop extending the selection, press F8 again.
#3)
Selecting a large range of cells:
Click the first cell in the range (B2 here), and then hold down SHIFT while you click the last cell (H33 here) in the range. You can scroll to make the last cell visible if necessary.
#4)
Selecting all cells on a worksheet:
Click the Select All button.
#5)
Selecting nonadjacent cells or nonadjacent ranges:
#6)
Selecting an entire row or column:

Summary

In a worksheet, you can select cells, ranges, rows, or columns. This is an important skill which allows you to, for example, apply the same formatting change to all of the selected cells. You can also select all or part of the cell contents and turn on Editing mode to modify the data within a cell.