Select colums or rows

Select a column or row

To select a column or row, use one of the following methods:

–Hover the cursor over a column or row heading so that the cursor looks like or . Left-click the heading.

–Click any cell in the row or column you want to select. To select a row, press Shift+Space. To select a column, press Ctrl+Space (Windows, Linux) or ⇧Shift+⌘Cmd+Space (macOS).

To select all rows that contain the merged cell, select the cell and press Shift+Space.

To select all the columns that contain the merged cell, select the cell and press Ctrl+Space (Windows, Linux) or ⇧Shift+⌘Cmd+Space (macOS).

Select a range of adjacent columns or rows

To select a small range of adjacent columns or rows, follow the steps below:

1.Hover the cursor over the heading of the first item to be selected so that the cursor looks like or .

2.While holding down the left mouse button, drag the cursor over the headings of the items you want to select.

3.Release the left mouse button.

To select a range of adjacent columns or rows that extends beyond the visible area of the spreadsheet, follow these steps:

1.Hover the cursor over the heading of the first item to be selected so that the cursor looks like or .

2.Select this heading with a left mouse click.

3.Hover the mouse cursor over the heading of the last item to be selected so that it looks like or . Click the heading while holding down the Shift key.