Page 25 - Excel Data Analysis

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

GETTING STARTED WITH EXCEL 1

You can quickly eliminate any unwanted named You can use dates as the names for your ranges.
ranges using the Define Name dialog box, which However, if your labels are numeric dates, Excel
you display by clicking Insert ➪ Name ➪ Define. must reformat the label to match the name rules.
The Define Name dialog box lists all of the For example, 1/31/2002 begins with a number and
names defined within the current workbook. To contains a slash character, which you cannot use in
delete a named range, click it and then click range names. If this date exists in a label column
Delete. Excel only deletes the range name. It that you use to create names, Excel changes the
does not delete any data. range name to _1_31_2002. See "Name a Range" for
more on naming ranges. See Excel Help for specific
You can change a range from the Define Name range naming rules.
dialog box by selecting the desired range,
specifying the range of cells in the Refers To
field, and clicking Add. To create a new range of
cells, type the new range name in the Names in
workbook field, specify the desired range in the
Refers To field, and click Add.

A1

■ The Create Names dialog ‹ Click the option ■ Excel creates the range ■ Click next to the Name
box displays. corresponding to the names. field to see the current range
location of the labels. names.
› Click OK.

11