Select colums or rows

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 ( 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.

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.

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 ( or ).

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 ( or ).

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 ( or ). Click the heading while holding Shift pressed.