You can select a single cell or a rectangular area of cells in the spreadsheet. The selected cell(s) are displayed with a thick black border.
You can select a single cell in one of the following ways
click on it
enter the cell reference (for example
B5) into the cell reference box at the left end of the Cell Editor tool options and press Enter
use the → menu option
You can also steer your way around with the arrow keys. Pressing the Enter key will move the current selection one position up, down, left or right depending on the setting in the Interface page of Calligra Sheets's configuration dialog box.
If you hold the Shift key down while using the arrow keys the selection will move to the start or end of the block of occupied cells.
To select an area of contiguous cells drag the mouse cursor across the
desired area with the Cell Editor cell reference box (for example
B7:C14) and press Enter, or enter these cell references
in a similar format into the dialog box brought up by → .
You can also select an area of cells by selecting the cell in one corner of the wanted area then holding the Shift key down while using the mouse button to select the cell in the opposite corner.
To select non-contiguous cells, click on the first cell you want to select then hold the Ctrl key and select the other cells.
To select a complete row or column of cellsclick on the row number at the left of the worksheet or on the column letters at the top. To select adjacent rows or columns drag the mouse pointer over the appropriate row numbers or column letters with the button held down.
To select non-contiguous rows or columns of cells, click on the first row number or column letter then hold the Ctrl key and select the other rows or columns of cells.