Selecting Nonadjacent Cells in Excel

For Windows users:

Select the first cell or range of cells, and release the mouse button. Then press and hold down the CONTROL key while you use the mouse to select the other cells or ranges. Release the mouse button, then release the control key.

 

For Mac users:

Select the first cell or range of cells, and release the mouse button. Then press and hold down the COMMAND key (a.k.a. the apple key) while you use the mouse to select the other cells or ranges. Release the mouse button, then release the command key.