Select cell ranges

Select an arbitrary range of adjacent cells

To select an arbitrary range of adjacent cells, use one of the following methods:

–Move the cursor to the first cell in the desired range. Hold down the left mouse button and drag the cursor to the last cell of the range. Release the left mouse button.

–Select the first cell of the desired range. Hold the Shift key pressed and select the last cell of the range.

The desired range can be selected in any direction of the row or column.

Examples of selecting an arbitrary range of adjacent cells:

Select all cells in the sheet

To select all cells within the workspace of the current sheet, do one of the following:

–Move the cursor to the upper left corner of the workspace so that the cursor changes to , and left-click.

–On the Home tab, in the Edit, click  Select all.

–When working in macOS, select Edit > Select all command from the command menu.

–Press Ctrl+A (Windows, Linux) or ⌘Cmd+A(macOS).

When you use these commands, only cells on the current sheet are selected. Cells on other sheets of the spreadsheet are not selected.

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

Deselect

To deselect the range, left-click any cell in the sheet.