A workbook can have any number of names. If you have many names, you should know about the Name Manager, shown in Figure 14-23.

FIGURE 14-23
The Name Manager is new in Excel 2007.

The Name Manager appears when you choose Formulas?Defined Names?Name Manager (or press Ctrl+F3). The Name Manager has the following features:

• Displays information about each name in the workbook. You can resize the Name Manager dialog box and widen the columns to show more information. You can also click a column heading to sort the information by the column.
• Allows you to filter the displayed names. Clicking the Filter button lets you show only those names that meet a certain criteria. For example, you can view only the worksheet level names.
• Provides quick access to the New Name dialog box. Click the New button to create a new name without closing the Name Manager.
• Lets you edit names. To edit a name, select it in the list and then click the Edit button. You can change the name or the Refers To range or edit the comment.
• Lets you quickly delete unneeded names. To delete a name, select it in the list and click Delete.

If you delete the rows or columns that contain named cells or ranges, the names contain an invalid reference. For example, if cell A1 on Sheet1 is named Interest and you delete row 1 or column A, the name Interest then refers to =Sheet1!#REF! (that is, to an erroneous reference). If you use Interest in a formula, the formula displays #REF.

To create a list of names in a worksheet, first move the cell pointer to an empty area of your worksheet— the list is created at the active cell position and overwrites any information at that location. Press F3 to display the Paste Name dialog box, which lists all the defined names. Then click the Paste List button. Excel creates a list of all names in the workbook and their corresponding addresses.

• Buying Wine in Restaurants Ordering a bottle of wine at a restaurant can be confusing and even daunting. Many times, what little information available...
• Search Engine Friendly Content Management Systems What is a Content Management System? A Content Management System (CMS) is a third party software application which allows web...
• Are You A Pay-Per-Click Dumb-Ass Excuse my title but the sole issue worse than not using Paid Click as part of your promoting tactics is...
• Review: YOU on a DIET: The Owner's Manual for Waist Management by Michael F Roizen, M.D. and Mehmet C. Oz, M.D Title - YOU on a DIET: The Owner's Manual for Waist Management Author - Michael F Roizen, M.D. and Mehmet...
• Open a Beer Bottle with a Piece of Bread, and 999 Other Ways Okay, this is not my original list, but this IS a life-saving list worth mentioning. Studying this list will result...