next up previous contents index
Next: 5.7.3 Selecting Ranges Using Up: 5.7 Selecting Cells and Previous: 5.7.1 Selecting Ranges Using

5.7.2 Selecting Ranges Using the Select Operations

     

For large or remote ranges, using the keyboard or mouse to highlight the range can be cumbersome. It is much easier to select the range by specifying the cell addresses of two opposite corners of the range. The Select... operation (from the Edit menu) displays a dialog box for that purpose. The Select Range dialog works for any NExS operation.

To select a cell using the Select Range operation:

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

  2. In the Selection entry box, type the cell address or range in the dialog box. For example, type in B17. Named ranges can also be used.

  3. Apply your selection by clicking OK or Apply or by typing [Return].

To select a range of cells using the Select operation:

  1. Choose Select... from the Edit menu. NExS displays a the Select Range dialog box as shown in Figure 5.3.

  2. In the Selection entry box, type the addresses of two cells in opposite corners of the desired range, separated by two periods (..). For example, to select a range from A14 to B27, type A14..B27. Named ranges can also be used.

  3. Apply your selection by clicking OK or Apply or by typing [Return].

   figure1158
Figure 5.3: Select Range Dialog Box

To select all occupied cells using the Select All command, choose Select All from the Edit menu. NExS selects the range which covers all occupied cells in the spreadsheet.


If you are working in edit mode or input mode, NExS assumes that Select All is meant to be an insertion into the content of the current cell. Therefore, NExS does not leave the selection highlighted for subsequent action; it inserts the range address into the edit line text at the current cursor position.


next up previous contents index
Next: 5.7.3 Selecting Ranges Using Up: 5.7 Selecting Cells and Previous: 5.7.1 Selecting Ranges Using

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