Using named cells in formulas, Replacing cell references with named cells – Apple AppleWorks 5 : Windows 95/NT 4.0 User Manual
Page 148
7-14
AppleWorks 5 User’s Manual
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-20 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 Help menu and type the first few letters of the entry. Double-click the
entry and then double-click a 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.
Replace cell addresses with
named cells or ranges in
formulas
Select the cell or range that holds the formula you want to work
with. Choose Replace References from the
menu in the entry
bar. Then deselect the cell addresses that you want to exclude
from replacement with named cells or ranges and click Replace.
In the Help index,
*
see:
E
formulas, spreadsheet
E
named cells and ranges