To Select Non-continuous Group of Cells:
1. Place the cursor in cell A1.
2. Press the left mouse button.
3. While holding down the CTRL key and left mouse button, move mouse from starting cell to ending cell. Holding down the Ctrl key enables one to select non–contiguous areas of the worksheet.
4. Perform the desired operation or Press Esc and click anywhere on the worksheet to remove the highlighting.