Using named cells in formulas, Replacing cell references with named cells – Apple AppleWorks 5 : Mac OS User Manual
Page 160
7-14
AppleWorks 5 User’s Manual
Note When you edit a name, AppleWorks updates all of the formulas that
use the name you edited.
Using named cells in formulas
Once you’ve named cells and ranges, you can use the names in place of cell
addresses in formulas. You can also use a name in a formula before it has
been defined to refer to a particular cell or range. (For information on
entering formulas, see “Working with formulas” on page 7-21 and onscreen
Help.)
Replacing cell references with named cells
You can replace named cells or ranges (such as Shares or Price) with cell
addresses (such as A5 or B1..B3) in a formula. To do so, choose Replace Names
from the
menu in the entry bar. To replace cell addresses with named
cells or ranges in a formula, choose Replace References from the
menu in the
entry bar.
*
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
Do this
Use named cells or ranges in a
formula
Select a cell and begin typing the formula. Then, add
named cells or ranges where you would normally add
cell and range addresses.
To add a named cell or range to a formula, choose the
name from the
menu in the entry bar. (You can also
type the name directly into the formula.)
Enter named cells or ranges in a
formula before you define the
names
Select a cell and begin typing the formula. Then type the
name you want to define, and finish entering the
formula. You see #NAME! in the cell (because you
haven’t assigned the name to any cells yet).
Assign a name to a cell or range
Select the cell or range to name and choose Define Name
from the
menu in the entry bar. In the Define Named
Range dialog box, choose a name from the pop-up
menu, and then click Define.
To
Do this
Replace named cells with
cell addresses in formulas
Select the cell or range that holds the formula you want to work
with. Choose Replace Names from the
menu in the entry bar.
Deselect the names you want to exclude from replacement
with cell addresses and click Replace.
In the Help index,
*
see:
E
formulas, spreadsheet
E
named cells and ranges