This dialog can be used to change the names of the columns within a spreadsheet.
Individual columns can be renamed by clicking on the left hand side
of a column title (indicated by the cursor changing to a pencil).
Column Names
The current column names are listed in order in the Column
name list box. A name can be changed by selecting the name
within the list (either using the mouse or cursor keys),
editing the details within the edit box at the top of the list and
then pressing the Enter key to enforce the change. Note that a
name is only updated in the list by pressing return, so if another
column name is selected without pressing return no change will be made.
Replace
This opens the Replace dialog
which allows you to change parts of names for some or all of the columns that match
a specified string. For example, a find string of "X" and
a replace string of "X[" on the column names X1,X2...X10 will create
the new names X[1,X2[...X[10.
OK
Change the names of the columns to those shown in the list.
Cancel
Close the dialog without making any changes.
See Also
Spreadsheet Column Menu
Rename Column Cursor