Microsoft Office Tutorials and References
In Depth Information
The list of names does not include hidden names or worksheet-level names that appear
in sheets other than the active sheet.
Figure 3-9: Use the Paste Name dialog box to create a list of names.
The list of names pasted to your worksheet occupies two columns. The first column contains the names, and the
second column contains the corresponding range addresses. The range addresses in the second column consist
of text strings that look like formulas. You can convert such a string to an actual formula by editing the cell.
Press F2 and then press Enter. The string then converts to a formula. If the name refers to a single cell, the for-
mula displays the cell's current value. If the name refers to a range, the formula may return a #VALUE! error,
or, in the case of multisheet names, a #REF! error.
I discuss formula errors such as #VALUE! and #REF! in Chapter 22.
Using names in formulas
After you define a name for a cell or range, you can use it in a formula. For example, the following formula cal-
culates the sum of the values in the range named UnitsSold: