O'Reilly logo

Microsoft® Office Home and Student 2007 Step by Step by Joan Lambert, Curtis Frye, Joyce Cox

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

7 Performing Calculations on Data

To create a named range from selected cells

  1. On the Formula Bar, click the Name Box.

  2. Type the name you want for the range, and then press .

To create a named range from a selection including the name

  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 for the cell that contains the name you want. Then click OK.

To display the Name Manager

  • On the Formulas tab, in the Defined Names group, click Name Manager.

To edit a named range

  1. On the Formulas tab, in the Defined ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required