O'Reilly logo

Microsoft® Office Excel® 2003 Step by Step by Curtis Frye

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

Chapter 3 Performing Calculations on Data

Naming Groups of Data To name a range of cells

  1. Select the cells to be included in the range.

  2. Click in the Name box.

  3. Type the name of the range, and press .

Naming Groups of Data To name a range of cells using adjacent cell labels

  1. Ensure that the desired name for the cell range is in the topmost or leftmost cell of the range.

  2. Select the cells to be part of the range.

  3. On the Insert menu, point to Name and then click Create.

  4. Select the check box indicating the location of the cell with the name for the range, and then click OK.

Finding and Correcting Errors in Calculations To write a formula

  1. Click the cell into which ...

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