Apple AppleWorks 5 : Mac OS - Manual (Page 159)

Spreadsheet 7-13
Assigning names to cells
To name cells, choose commands from the menu in the entry bar
.
Note Some characters, such as operators (like + or ÷ ) and punctuation
marks cannot be included in a cell name. For complete information about
naming a cell, see onscreen Help.
Editing and deleting names
If you change your mind about the name or location of a named cell or range,
or if you want to delete a name, choose Edit Names from the
menu in the
entry bar. Then, make changes in the Edit Names dialog box.
To Do this Example
Name a cell or cell range Select the cells to name and
choose Define Name from the
menu. Type a name in
the dialog box, and then
click Define.
Name cells or ranges using
row and column titles
you’ve already typed Select all of the cells to
name (include both row and
column headings in the
selection) and choose Auto
Name from the
menu in
the entry bar. Select a name,
then click Define.
You can assign more than
one name to a cell or range.
* Choose Index from the or Help menu and scroll to the entry. Then choose a topic from
the list and click Go To Topic.
To Select a name from the scrolling list, and then
Rename a cell or range Type a new name, and then click Modify
Change the cell address
referenced by a name Type a new address for the cell or range, and then click Modify
Delete the name of a cell or
range Click Remove.
If the name you want to delete is used in a formula, you must
first replace the names in the formula with cell references. (See
“Replacing cell references with named cells” on page 7-14.)
Cell A1 is
unnamed Cell A1 is
named
Revenue
Cells B3 and C3 are named Shares
Cells B4 and C4 are named Price
Cells B3 and B4 are named January
Cells C3 and C4 are named February
In the Help index, * see:
E
named cells and ranges