Working with Range and Cell Names

Once 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 refer to, particularly if you are 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). Press F3, excel displays the Paste Name dialog box that lists all the defined names. To paste a list of names, click the Paste List button.

The list of names does not include 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 addesses 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, then press Enter). The string then converts to a formula. If the name refers to a range, the formula returns a #VALUE! error.