Next: 5.7.3 Selecting Ranges Using
Up: 5.7 Selecting Cells and
Previous: 5.7.1 Selecting Ranges Using
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:
- Choose Select... from the Edit menu. NExS displays
the Select Range dialog box as shown in
Figure 5.3.
- 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.
- Apply your selection by clicking OK or Apply or by
typing [Return].
To select a range of cells using the Select operation:
- Choose Select... from the Edit menu. NExS displays a
the Select Range dialog box as shown in
Figure 5.3.
- 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.
- Apply your selection by clicking OK or Apply or by
typing [Return].
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: 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