O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

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

Defining Label Ranges

You can define label ranges on your worksheets so that you can use the label names, instead of cell references, in formulas. You can even specify label ranges that contain row and column labels on your worksheet. Naming a cell or range of cells is a major shortcut for referring to long cell addresses in formulas or row and column labels on worksheets.

Adding Names

To add a name, select the cell or range of cells you want to name. Then choose Insert, Name, Label. The Label Ranges dialog box pops up, as shown in Figure 16.14.

Figure 16.14. The Label Ranges dialog box.

The range you selected appears in the Add Label Range box. ...

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