To select noncontiguous rows, click the row number of a row you want to select. Either way, you’ll select a range of rows. Or, if you prefer, you can hold down your Shift key and click the bottom-most row you want to select. To select a contiguous set of rows, click the row number of the first row.Ĭontinuing to hold down your mouse button, drag your cursor across all the rows you want to select. If you know the exact range of cells you want to select, using the name box is a useful way to make the selection without any clicking or dragging. Select a Range of Cells Using the Name Box In the image below, we deselected several cells from a range of cells we’d already selected just by holding down the Ctrl key while clicking the cells. You can also use your Ctrl key to deselect an already selected cell-even from a selection range. In the image below, we’ve selected five different cells. Now, hold down the Ctrl key and click to select additional cells. 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.
