1. Home
  2. Rename Columns

Rename Columns

Select menu: Spread | Column | Rename

Use this to change the names of all the columns within a spreadsheet. The individual columns can be renamed by editing the names within spreadsheet. If the columns include descriptions then these can also be displayed and edited.

  1. With your spreadsheet displayed, from the menu select Spread | Column | Rename.

Names

The Names column names lists the columns in the order they appear in the spreadsheet. You can change a name by selecting the name within the column and editing its value.

Behaviour with Unicode text in a column

When a column in the spreadsheet contains Unicode, you will not be able to edit the labels directly. An attempt to edit a cell will open the Edit Unicode Text dialog which accepts Unicode characters. You can still use the clipboard shortcut keys for copying (Ctrl+C), cutting (Ctrl+X) and pasting (Ctrl+V) Unicode text in this dialog. See Working with Unicode in a Spreadsheet for more information on working with Unicode text.

Descriptions

When the Show descriptions checkbox is selected a second column is displayed in the spreadsheet enabling you to edit the description associated with the column.

OK Make your changes and close the dialog.
Cancel Close the dialog without making any changes.
Copy Copies the contents of the current cell or a selection of cells onto the clipboard.
Paste Paste the contents on the clipboard starting from the current cell.
Find Finds specified text within the names or descriptions.
Replace Find and replace specified text within the names or descriptions. You can search within the names by placing the cursor in the Names column and similarly you can find text within the descriptions when the cursor is within the Descriptions column.
Pointer Automatically rename the columns as a pointer data structure.
Clear Clears the items within the Names or Descriptions columns. To delete the contents of the column either select the column or place the cursor within the column.

See also

Updated on January 27, 2022

Was this article helpful?