Page 22 - Excel Data Analysis

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

EXCEL DATA ANALYSIS

NAME A RANGE

f you need to reference a specific range of cells in You create the range name in the Define Name dialog box.
multiple locations, it can become tedious to remember Your range names can consist of up to 255 characters, but
I the cell locations. You can create range names to easily you only see about the first 16 characters of the name in the
locate specific information, to avoid having to remember Name box. Therefore, you may want to use names that you
the cell locations, and for use in any formulas that you can easily distinguish after viewing the first few characters.
create. For example, if you create a range name in Sheet1 Excel only allows you to use a range name once in a
named Sales_Amounts, in Sheet2 you can create a formula workbook; therefore, if you have a duplicate name in
that sums the range by typing the following:
another worksheet, you must use a different name. If you
create a range name that already exists, Excel replaces the
=SUM(Sales_Amounts)
previously specified range with the new range. To avoid
Using the named range eliminates the need to specify a potential errors, verify that you have a unique range name
worksheet or cell reference. Although the example shows before using it.
how to access a range from any worksheet in the same
workbook, you can also reference a named range of cells If you duplicate a worksheet containing a named range, Excel
from another workbook. For example, =SUM(Sales2002! only recognizes the range name in the original worksheet for
Sales_Amount) references a named range in the other worksheets in the workbook. You can only access the
workbook Sales2002.xls. See Chapter 4 for more copied range name on the copied worksheet.
information on creating formulas.

NAME A RANGE

⁄ Select the range of cells Note: See the section "Select a ¤ Click Insert ➪ Name ➪
that you want to name. Range of Cells" for more information Define.
on selecting a range.

8