You can also select multiple cells that are not connected to one another by using your Ctrl key.
Select (or Deselect) Independent Cells Outside a Range With the Ctrl Key
Hold down your Shift key, and then click that cell.Īll the cells in the range are now selected. Scroll your sheet until you find the last cell in the range you want to select. Click the first cell in the range you want to select.
