Page 26 - Excel Data Analysis

02 537547 Ch01.qxd 3/4/03 11:45 AM Page 12

EXCEL DATA ANALYSIS

MODIFY NAMED RANGES

fter you create a named range, Excel continues to You use the Define Names dialog box to modify a named
use the stored named range whenever you refer to it range. In this dialog box, you select the desired range name
A with the assigned range name. If you change the and make the appropriate modifications either by entering
worksheet by adding or removing corresponding data them in the Refers to field or by using the Collapse Dialog
values, you must update the corresponding named ranges button to select a new range of cells. If you have multiple
so that Excel references the appropriate cells when you use ranges to modify, you can use the Add button to save the
that range name. To create named ranges, and for more on changes to the first named range and then modify the next
the benefits of using them, see the section "Create Label range name.
Ranges."
If you change the actual range name in the Define Names
When you modify a named range, the changes affect every dialog box, Excel actually creates a new range name and
location that refers to the corresponding range. For keeps the old range name. You can delete the old range
example, if you create a formula that uses a specific named name using the Delete button. See "Create Label Ranges"
range, and then change the cells that the range name for information on deleting a range name.
references by deleting a column of data, the formula
continues to reference the new version of the named range.
See Chapter 4 for more information on creating formulas.

MODIFY NAMED RANGES

Parking Sheet2

⁄ Click Insert ➪ Name ➪ ■ The Define Name dialog ¤ Click the name of the
Define. box displays. range you want to modify.
‹ Click the Collapse
Content button.

12