Select menu: Spread | Select | Columns
Use this to select columns within a spreadsheet to enable an action to be done on all the selected columns, for example editing their attributes or copying the cell contents on to the clipboard. The selected columns are displayed with the flag Sel beside the column name.
- From the menu select Spread | Select | Columns.
You can also select multiple columns by holding down the Ctrl key and clicking the column names. A column selection can be extended using the Shift and left or right arrow keys or the Shift and Home or End keys.
The selected columns are displayed in grey (if the default colours are used).
|Action||Choose whether to Select a column.|
|Column||Displays the name of each column.|
The action status can be changed by either double clicking a row associated with a column, or by selecting one or more rows (using the Shift and Ctrl keys with the left mouse click, or using the Shift key with up and down keys) and then clicking either the Select or Unselect buttons.
Change the status of selected columns in the column list to be in the list of selected columns.
Change the status of selected columns in the column list to be removed from the list of selected columns.