2007 Microsoft® Office System Step by Step

Performing Calculations on Data

To create a named range

1. Select the cells you want to name.

2. Click the Name Box on the Formula Bar.

3. Type the name you want for the range.

4. Press .

To create a named range from a selection

1. Select the cells you want to name as a range. Be sure either the first or last cell contains the name for the range.

2. On the Formulas tab, in the Defined Names group, click Create from Selection.

3. Select the check box that represents the cell that contains the range’s desired name.

4. Click OK.

To display the Name Manager

• On the Formulas tab, in the ...