Brother Ensemble PDP-100J, Owner'S Manual

Page: 184 / 440

Spreadsheet 170
You define a name that refers to a specific cell or range. For example, you
might define RATE as A3; then, when entering formulas, you can type
RATE insteadof typing A3 .
You can use both absolute andrelative references when you define a
name. For example, if you have name $C1 = Income when defined in row
1, but when Income is pastedinto row 6, the reference becomes $C6. The
reference to column C remains constant (absolute) regardless of where
you paste the namedcell.
"
To define a name:
1. Choose Define Name from the Formulas menu. The dialog box below
appears, listing any names you have previouslydefined.
2. Click on New. Another dialog box appears.
3. Fill in the dialog box, specifying the name and reference you want to
use:
S
Name. Enter the name for the cell or range of cells. Use absolute
cell addresses unless you want the named range to reflect a
relative position.
S
Definition . Enter the reference for the cell or range you want to
name. You can use relative andabsolute references.
4. Click on OK. Thename appears in the list in the Define Name dialog box.
5. Click on Close. The dialog box disappears.
To help you remember the
location or definition of the cells
you want to name, you may want
to select it first so that the
location appears in the Edit Bar
.