Page 132 - Excel 2007 Bible

09_044039 ch05.qxp 11/21/06 10:56 AM Page 89
Working with Cells and Ranges
FIGURE 5.13
Use the Create Names From Selection dialog box to name cells using labels that appear in the worksheet.
If the upper-left cell of the selection contains text and you choose the Top Row and Left
CAUTION
CAUTION
Column options, Excel uses that text for the name of the entire data excluding the top row and
left column. So, before you accept the names that Excel creates, take a minute to make sure that they refer 5
to the correct ranges. If Excel creates a names that is incorrect, you can delete or modify it by using the
Name Manager (described next).
Managing Names
A workbook can have any number of names. If you have many names, you should know about the Name
Manager, shown in Figure 5.14.
FIGURE 5.14
The Name Manager is new in Excel 2007.

89