Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 2 Working with Data 53

All of the workbooks you’ll use in this book will contain range names for

each of their data columns.

EXCEL TIPS

Another way to create range names is by fi rst selecting the cell

range and then typing the range name directly into the Name Box.

You can view and organize all of the range names in the current

workbook by clicking the Name Manager button located in the

Defi ned Names group on the Formulas tab.

Range names have a property called scope that determines

where they are recognized in the workbook. Scope can be lim-

ited to the current worksheet only, allowing you to duplicate

the same range name on different worksheets. If you wish to

reference that a range name with a scope limited to a particular

worksheet, you’ll have to specify which worksheet you want to

use. For example, you must use the reference ‘Sheet 1’!Gas for

the cell range “Gas” located on the Sheet 1 worksheet.

You replace cell references with their range names by clicking

the Defi ne Name list button from the Defi ned Names group on

the Formulas tab and then selecting Apply Names from the list

box. You will then be prompted to apply the already-defi ned

range names to formulas in the workbook.

•

•

•

•

Figure 2-13
Selecting
the Total
range

Name box

contains

a list of range

names in the

current

workbook/

worksheet

the Total range