Owner's manual

Spreadsheet 7-15
Example 1: Using cell names in a formula
This example shows you how to name two cells and use the names in a
formula.
1. Open a new, blank spreadsheet document, and then type Income, Expenses,
and
Profit in cells A1, A2, and A3, respectively.
2. Format column B for currency.
Select the entire column, click on the Default button bar (or choose
Number from the Format menu, select Currency, and then click OK).
3. Select cell B1 and choose Define Name from the menu in the entry bar.
4. Click Define to accept the suggested name, Income.
5. Select cell B2 and choose Define Name from the menu in the entry bar.
6. Click Define to accept the suggested name, Expenses.
7. Cells B1 and B2 are now named Income and Expenses.
8. Type 1000 and 800 in cells B1 and B2, respectively.
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.
To Do this
Cell name appears here