Select Columns in a Spreadsheet

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.

1. 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).

Column list

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.

Select

Change the status of selected columns in the column list to be in the list of selected columns.

Unselect

Change the status of selected columns in the column list to be removed from the list of selected columns.

See also

• Select menu for selecting column, rows or cell ranges in the spreadsheet.
• Spreadsheet toolbar.