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

330 Range Names in Formulas
Figure 1-15:
The Name Manager lists all range names defined
in the workbook.
The Name Manager enables you to do any of the following:
✦ Create new range names for the worksheet or workbook in the New Name dialog box opened by clicking the New button. (See “Defining range names” earlier in this chapter.)
✦ Edit existing range names in the Edit Name dialog box by clicking the name in the list box and then clicking the Edit button — you can change both the name and cell selection when editing a range name.
✦ Delete existing range names by clicking the name and then clicking the Delete button followed by the OK button in the Alert dialog box asking you to confirm its deletion.
✦ Filter the range names in the list box of the Name Manager by clicking the Filter button and then choosing a filter option (Names Scoped to Worksheet, Names Scoped to Workbook, Names with Errors, Names without Errors, Defined Names, or Table Names) from its drop-down menu.
Be careful that you don’t delete a range name that is already used in formu- las in the worksheet. If you do, Excel will return the #NAME! error value to any formula that refers to the name you deleted!
Applying names to existing formulas
Excel doesn’t automatically replace cell references with the descriptive names that you assign to them in the New Name or Create Names from Selection dialog boxes. To replace cell references with their names, you