next up previous contents index
Next: 5.11 Named Ranges Up: 5 Manipulating the Spreadsheet Previous: 5.9 Reselecting a Range

5.10 Specifying Cells and Ranges in Dialog Boxes

     

Some NExS editing operations such as Select Range and Go To display a dialog box in which you specify a cell.

To specify a cell in a dialog box:

Enter the address of the cell. For example: A1.

OR

Use the mouse to point to the cell, and then click the left mouse button. Now position the mouse over the dialog entry and press the middle mouse button. NExS pastes the cell name into the dialog as a relative reference. To paste an absolute reference, hold the Ctrl key when you press the middle mouse button.

To specify a range in a dialog box:

Type the addresses of opposite corners of the range, separated by two periods (..). For example: A1..E5.

OR

Use the mouse or keyboard to highlight the range of cells. Now position the mouse over the dialog entry and click the middle mouse button. NExS pastes the cell range into the dialog as a relative reference. To paste it as an absolute reference, hold the Ctrl key when you click the middle mouse button.


If you have previously assigned a name to a cell or cell range using the Named Range dialog, you can specify cells and ranges by this name rather than by pointing or by coordinates.


next up previous contents index
Next: 5.11 Named Ranges Up: 5 Manipulating the Spreadsheet Previous: 5.9 Reselecting a Range

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