next up previous contents index
Next: 5.12 Copying Data Up: 5 Manipulating the Spreadsheet Previous: 5.10 Specifying Cells and

5.11 Named Ranges

     

Individual cells and rectangular ranges of cells may be referred to by their standard address coordinates (A5..D25, for example) or by pre-assigned names. Using names can help clarify the logic of your spreadsheet, making it easier to share among users, and easier to update long after it was originally designed. The Named Range option lets you assign a name to any cell or range. Once defined, names can be used anywhere standard cell or range references are used including cell formulas.

The following guidelines apply to named ranges:

To name a cell or range:  

  1. Select the cell or range to be named.

  2. Select Named Range... from the Edit menu. NExS displays the Named Range dialog box as show in Figure 5.4.

  3. In the Selection entry box, the current cell or range is displayed. Click on the entry box before the equal (=) sign and enter a name.

  4. Click Set or press [Return]. Click Cancel to dismiss the dialog box.

To clear the name from a cell or range:  

  1. Select Named Range... from the Edit menu. NExS displays the Named Range dialog box as shown in Figure 5.4.

  2. Click on an entry in the Named Range List box. NExS displays your choice in the Selection entry box.

  3. Click Clear.

   figure1232
Figure 5.4: Named Range Dialog Box


next up previous contents index
Next: 5.12 Copying Data Up: 5 Manipulating the Spreadsheet Previous: 5.10 Specifying Cells and

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999