Skip to main content

Select cells

You can select individual cells, ranges of cells, non-contiguous cells, rows, columns, and entire tables.

When you switch to another sheet, the current selection is retained.

Select a range of cells with the mouse​

  1. Hover the cursor over the first cell of the range you want to select.
  2. Hold down the left mouse button and drag the cursor to the last cell of the range.

Select a range of cells using the Shift key​

  1. Set the cursor in the first cell of the range.
  2. Hold down Shift and left-click on the last cell of the range.
  3. To adjust the selected range, hold down Shift and press the arrow keys.

Select rows or columns​

  • To select a single row or column, click on the row or column header.
  • To select multiple rows or columns, hold down the left mouse button and drag across the headers, or use Shift.
  • To expand or narrow the range, hold down Shift and press the arrow keys.

Select non-contiguous cells, ranges, rows, or columns​

  1. Select a cell or range of cells.
  2. Hold down Ctrl (Cmd) and select another cell, range of cells, row, or column.

Select the entire table​

  1. Select any cell in the table.
  2. Press Ctrl+A (Cmd+A).