Page 23 - Excel Data Analysis

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

GETTING STARTED WITH EXCEL 1

If you no longer want to use a named range, If you have a worksheet that includes formulas that
you can delete it by clicking Insert ➪ Name ➪ reference cells from a named range, you can convert
Define. In the Define Names dialog box, select the cell references to the range name. To do so, select
the range name and click Delete. the cells containing the formula and click Insert ➪
Name ➪ Apply to display the Apply Names dialog
When you delete a named range, you only box. The dialog box displays the names that exist
remove the name. The cells referenced by the within the workbook. Click OK to update the formula
name remain unchanged. If you have a formula in the selected cell to include the named ranges.
that references the deleted range name, the
error #NAME ? displays in the cell containing the Keep in mind that Excel only updates the range
reference. You must update each formula that names within the existing worksheet and not those
references the deleted range name. in other worksheets.

C6

■ The Define Name dialog ■ You can click the Collapse ■ Excel creates the new ■ You can click next to the
box displays. Content button to make a range name. Name field to see the current
previously assigned range range names.
‹ Type the name of the appear in the Refers to box.
range.
› Click OK.

9