Selects a rectangular part of the current spreadsheet, consisting of one or
more rows and columns or a block of values. Selected cells are indicated by
highlighting. The selection can be copied or cut to the Clipboard or used as
the destination for a paste command.
All
The entire spreadsheet is selected.
Range
Opens a dialog where a range of cells can be selected by specifying the start and end rows and
columns of a rectangular block of values. Existing row or column selections
will be deselected.
Current Column
Selects the current column. This will be added to an existing column selection;
other types of selection will be deselected.
Current Row
Selects the current row. This will be added to an existing row selection; other
types of selection will be deselected.
Clear
Clears the current selection.
Restricted Rows
Restricted rows (marked in red) are selected. If restricted rows are not
displayed in the spreadsheet, you can make them visible by clicking the
button.
Unrestricted Rows
All rows are selected, except those that are currently omitted by a restriction.
Unit Column
The Units column which displays an identifier for each row and is fixed to
the left hand side of the spreadsheet is selected.
Toggle Cell Selection
This menu item can be used to select any arrangement of cells using the cell selection
mode. The cell selection mode provides an alternative method for selecting cells to
the standard way of selecting rows, columns or blocks. Toggling the selection of a cell
automatically activates the cell selection mode and removes any previous row, column or
block selection. When in cell selection mode the background colour of the cells indicating
a selection is by default displayed in light blue. However, this colour can be changed
using the Cell Selection option for spreadsheets in the
Options - Fonts and Colours tab. Cells are included
or removed from the selection by placing the cursor in the required cell and selecting this
menu item. Data within the selected cells are copied to and pasted from the clipboard in
the order that the cells were selected. The cell selection mode is deactivated by removing
the selection by selecting the Clear item from the
Select submenu on the Spread menu. Alternatively,
the selection can be cleared by pressing the Esc key.
Swap Selected Cells
If cells have been selected using the cell selection mode, the contents in
the cells are exchanged in pairs. The first two selected cells will have their
contents swapped between them, and then the next two cells, and so on. If there
are an odd number of cells, then the last selected item is not included in the swap.
The following image shows some cells before and after the values have been swapped
using this menu item. The cells were selected in the order A(1),B(1),A(3),B(3),A(5),B(5)
using the Toggle Cell Selection menu item.
See Also