Page 343 - Excel 2013 All-in-One For Dummies

the Scope drop-down list box and the cell reference of the active cell or the range address of the range or nonadjacent selection that is currently marked (by using absolute references) in the Refers To text box below. You can do the following:
✦ To change the scope from the entire workbook to a particular work- sheet in the workbook so that the range name is only recognized on that sheet, select the sheet’s name from the Scope drop-down list.
✦ To change the cell range the name refers to, select the cells in the work- sheet. (Remember that you can collapse the New Name dialog box to the Refers To text box by clicking its Collapse button.)
✦ To accept the suggested or edited name, scope, and cell selection, click the OK button, shown in Figure 1-12.
Figure 1-12:
Adding a new range name in the New Name dialog box.
Range Names in Formulas 325
When naming a range in the Name text box of the New Name dialog box, you need to follow the same naming conventions as when defining a name in
the Name box on the Formula bar. Basically, this means that the name must begin with a letter rather than a number, contain no spaces, and not dupli- cate any other name in the workbook. (See Book II, Chapter 2 for more on naming ranges.)
If you want to assign the same range name to similar ranges on differ-
ent worksheets in the workbook, preface the range name with the sheet name followed by an exclamation point and then the descriptive name. For example, if you want to give the name Costs to the cell range A2:A10 on
both Sheet1 and Sheet2, you name the range Sheet1!Costs on Sheet1 and Sheet2!Costs on Sheet2. If you have renamed the worksheet to something more descriptive than Sheet1, you need to enclose the name in single quotes if it contains a space when you enter the range. For example, if you rename Sheet1 to Inc. Statement 04, you enter the range name including the work- sheet reference for the Costs cell range as follows:
‘Inc. Statement 04’!Costs
Book III Chapter 1
Building Basic Formulas