Microsoft Office Tutorials and References
In Depth Information
Appendix: Using the Names Menu in Excel 2003 and Mac Excel 2011
APPENDIX: USING THE NAMES MENU IN EXCEL 2003 AND MAC
In Excel 2003, or previous versions, the Names feature appears under the Insert
menu. In the following example, I will use the Excel menu to create names. In the
sheet Ranges of the Excel 2003 Chapter 4 workbook, I would like to create names for
the different ranges. See Figure 4.16. In this example, I would like to call the range
C3:C8 Sales, D3:D8 Cost and the range E3:E8 Profit. The other ranges will also be
named. C3:E3 will be named Jan, C4:E4 will be named Feb, C5:E5 will be named
Mar, and so on.
The header in row 2 and the information in column B will be used to create the
range names. As you select the range B2:E8 use: Insert
When you click on Insert
Create, the menu shown in Figure 4.18
allows you to create the names shown on the top row and the names in the left
column of the selected range.
Now that you have created these names, you can utilize them in formulas and
functions on the same sheet or other sheets in this workbook.
To change, edit, delete, or modify the names in Excel 2003 or a previous version,
Define. The Define Name menu will allow you to add, edit, or
delete any of the names as shown in Figure 4.19.
Excel Mac 2011
In Mac Excel 2011, the Names feature appears under the Insert menu. In the fol-
lowing example, I will use the Excel menu to create names. It is the same example
FIGURE 4.16 The Range for Names to Be Created