Selecting items in Calc

Almost anything you do in a spreadsheet involves selecting a row, column or group of cells.

Selecting rows

The easiest way to select a row is to click on the row header. To select several rows that are next to each other click and drag the mouse or you can click the row header of the first row, then click the last row while depressing the shift key.

OpenOffice Calc screenshot showing selected rows
To select rows that are not next to each other, hold the Ctrl key and click the row header of each row you want to select.

Selecting columns

Selecting columns works the same way. Click the column header to select a single column or c lick and drag to select multiple columns that are next to each other. To select columns that are not next to each other click each column header while holding the Ctrl key.

OpenOffice Calc screenshot showing selected columns

You can quickly select the entire spreadsheet by clicking the upper left corner of the header area or you can do the same thing by choosing select all from the edit menu.

Selecting cells

There are several ways to select a cell or a range of cells. To select a single cell, just click on it. You can click and drag to select a rectangular range of cells.

OpenOffice Calc screenshot showing selected cells

If you want to select more cells that aren't next to each other, hold the Ctrl key and click on each of the cells you want to include.

 

 
© copyright 2005 LearnOpenOffice.org