Microsoft Office Tutorials and References
In Depth Information
Working with Range and Cell Names
Working with Range and Cell Names
After you create range or cell names, you can work with them in a variety of ways. This section
describes how to perform common operations with range and cell names.
Creating a list of names
If you create a large number of names, you may need to know the ranges that each name refers
to, particularly if you’re trying to track down errors or document your work.
You might want to create a list of all names (and their corresponding addresses) in the
workbook. To create a list of names, first move the cell pointer to an empty area of your worksheet.
(The two-column name list, created at the active cell position, overwrites any information at that
location.) Use the Formulas
Paste Names command (or press
F3). Excel displays the Paste Name dialog box (see Figure 3-9) that lists all the defined names. To
paste a list of names, click the Paste List button.
Defined Names
Use in Formula
Figure 3-9: The Paste Name dialog box.
The list of names does not include hidden names, or worksheet-level names that appear
in sheets other than the active sheet.
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 formula 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 21.
Search JabSto ::

Custom Search