O'Reilly logo

StarOffice™ 5.2 Calc Handbook by Joe Habraken

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

Naming Cells and Ranges

A very useful technique for making it easier to refer to cell ranges in formulas (and functions) is to name the cells. The Cell Name feature allows you to assign a name to a cell or cell range. The name then rather than the cell or range address can be used to refer to the cells in a formula.

To Name a Cell Range

Naming a cell or cell range is accomplished via the Name command on the Insert menu.

1.
Select the cell or cell range that you will name.
2.
Select Insert, point at Names, and select Define. The Define Names dialog box will open (see Figure 5.7).
Figure 5.7. Enter the name for the cell or cell range in the Define Names dialog box.
3.
Type the name for the cell or cell range in the Name box.
4.
Click Add to ...

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