Browse » Home
Thursday, January 12, 2012
How to Name a Field in Excel 2003
1. Open the Excel Workbook that contains the field you want to name.
2. Select the cell, column or row you want to name. Select a cell by clicking it. Select a column by clicking the column letter at the top of the spreadsheet. Select a row by clicking the row number on the left side of the spreadsheet. Select disconnected cells, columns or rows by holding down the 'CTRL' key while you make your selections.
3. Select a range by clicking and dragging to include cells. Select disconnected ranges by holding down the 'CTRL' key while you make your selections.
4. Find the name box in the spreadsheet. It is to the left of the formula bar directly above the column letters. The address of the first cell you selected is visible in the name box--unless you selected multiple ranges, then the first cell in the last range of cells selected is visible in the name box.
5. Click in the name box and type in the name you are giving the cell or range. Press the 'Enter' key.
6. Click the drop-down arrow in the name box to see the names of all the cells and ranges you have named.
7. Open the 'Define Name' dialog box by pressing 'CTRL F3' to review the names you have created and the cells to which they refer. Click the 'Close' button when done.
8. Use a named cell or range in a formula by replacing the cell or range address with the name you defined. For example,give the range of cells from A1 to A5 (A1:A5) the name 'blue.' Assuming those cells contain numbers, you can use the formula '=sum(blue)' instead of '=sum(A1:A5).'
9. Highlight a named range when creating a formula to insert the range name automatically. For example, using the named range 'blue' in the sum function will insert blue ('=sum(blue)') in place of the range from A1 to A5 ('=sum(A1:A5)').