Apple M9057 User Manual - Page 161

Spreadsheet 7-15 To Do this Replace cell addresses with Select the cell or range that holds the formula you want to work named cells or ranges in with. Choose Replace References from the menu in the entry formulas bar. Then deselect the cell addresses that you want to exclude from replacement with named cells or ranges and click Replace. 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. Cell name appears here 8. Type 1000 and 800 in cells B1 and B2, respectively.