Click the cell you want to be the first cell in a range of cells (for example, B2).
Press and hold down the left mouse button while you drag the pointer to the last cell you want to include in the range (for example, E5).
When the desired range is selected, release the mouse button.
INTRODUCTION
Sometimes you'll want to select multiple cells that are adjacent to each other (known as a range). You will use this feature frequently when you are formatting your data and want to format multiple cells in the same manner.
TIP
Range References
A range of cells is indicated with a range reference. This includes the upper-leftmost cell in the selection, a colon, and the lower-rightmost cell in the selection. For example, the range reference for cells G2 through F9 would be G2:F9.
TIP
Using Shift
Another way to select a range of cells is to click a cell, press the Shift key, and then click the cell at the other end of the desired range. All the cells between the two clicked cells will be selected.