How can we help you?

Select a column or row

To select the entire column or row in a spreadsheet, do one of the following:

Hold the cursor over the heading of a row or column. The cursor will change to an arrow (down_arrow or right_arrow). 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.

To select all rows containing a merged cell, select the cell and press Shift+Space.

To select all columns containing a merged cell, select the cell and press Ctrl+Space.

Select a range of columns or rows

To select a range of rows or columns:

1.Hold the cursor over the heading of the first row or column that you want to select. The cursor will change to an arrow (down_arrow or right_arrow).

2.Press and hold the left mouse button and drag the cursor to the headings of the items to be selected.

3.Release the mouse button.

To select a range of rows or columns not included in the workspace area:

1.Hold the cursor over the heading of the first row or column that you want to select. The cursor will change to an arrow (down_arrow or right_arrow).

2.Left-click the heading to select it.

3.Hold the cursor over the heading of the last row or column that you want to select. The cursor will change to an arrow (down_arrow or right_arrow). Click the heading while holding Shift pressed.

Was this helpful?
Yes
No
Previous
Insert columns or rows
Next
Hide or unhide a column or row