Click the cell you want to make active (for example, B3). A thick, black border around the cell indicates it is the active cell.
Click another cell (for example, B8) to select it as the active cell. Notice that a border no longer appears around cell B3.
Press the Ctrl key on the keyboard and click cell B3. The active cell is B3, but cell B8 now has a light blue background, indicating that both cells are selected.
INTRODUCTION
Excel displays numerous rows and columns that make up thousands of cells. Most likely you won't use them all, but you do need a way to select specific cells and frequently select more than one cell at a time. When you want to select an individual cell, you just click it.
TIP
Unselecting Cells
If you click a cell that you didn't want in the selection, your only option is to release the Ctrl key and click somewhere in the worksheet to clear the noncontiguous range. Then, start selecting the cells again more carefully.
TIP
Selecting the Whole Worksheet
You can select an entire worksheet by pressing Ctrl+A. This is convenient when you want to format all the cells in a worksheet the same way for example, making everything bold, blue, and 16-point font.