Microsoft Office Tutorials and References
In Depth Information
Working with formulas
Figure 12-11 When you click Define Name on the Formulas tab, Excel suggests any label in an
adjacent cell in the same row or column as a name.
Figure 12-12 The Name Manager dialog box provides central control over all the names in a
The Name Manager dialog box lists all the names along with their values and locations.
You’ll see that the Refers To text box shows the definition of the name we just added,
=Sheet1!D20. Excel adds the worksheet reference for you, but note that the cell reference
stays relative, while the Region_1 definition created by Excel uses absolute references (indi-
cated by the dollar signs in the Refers To definition). In fact, after defining the name Test2
using a relative reference, if you click a different cell before you open the Name Manager