Manual

Once you have
defined a name,
you can usa it in
any formulas you
create. To do so,
type the name in
the formula. If you
prefer, you can also
select the name
from a list in a
dialog box.,
l_ To insert a name in a formula:
1. Select a cell and begin entering a formula.
2. When the insertion point in the Edit Bar is in the position for the name
you want to use, select Insert Name from the Formula menu. The Insert
Name dialog box appears, with the names you have created.
3. Select the name you want to insert.
4. Click on Paste./'be name appears in the Edit Bar.
5. Click on Close.
ff you change the
definition of a name,
the reference
changes in exfsting
formulas that contain
that name. For
example, if you have
a range called _ __
_penses that
includes B5:B17 and
you extend the range
to B5:B24, all
formulas using the
name Expenses will
be recalculated
automatically to
include the seven
additional cells in the
range. But if you
delete the name, all
formulas using that
name will be wrong.
I_ To change the name of a cell or range:
1. Select Define Name from the Formula menu. A dialog box appears.
2. Select the name you want to change.
3. Click on Change. A dialog box appears.
4. Type the new name in the Name box.
5. Click on OK. All formulas referring to the old name are updated to the new
name.
6. Click on Close.
!_ To change the definition of a name:
1. Select Define Name from the Formula menu. A dialog box lists existing
names.
2. Select the name for which you want to change the definition.
3. Click on Change.. _,. ,_
-4. Change the cell,or range specification to suit your needs. Use absolute'ceU
addresses unless you want the named range to reflect a relative position.
5. Click on OK. Spreadsheet updates all formulas to reflect the change.
6. Click on Close.
l_ To delete a name:
1. Select Define Name from the Formula menu. A dialog box appears.
2. Select the name you want to delete.
3. Click on Delete. You are asked if you want to delete the name.
4. Click on Yes to delete the name. Spreadsheet deletes the name.
Controlling Automatic Recalculation
Spreadsheet normally recalculates every formula in your spreadsheet when
you make a change. If your spreadsheet is large or contains many complex
formulas, this recalculation can be time consuming. In that case, you may
want to turn automatic recalculation off and recalculate the spreadsheet
manually whenever you want to.
Spreadsheet 100