next up previous contents index
Next: 9.5 Extract Up: 9 Shortcuts and Tools Previous: 9.3 Goal Seek

9.4 Sort

   

NExS can sort the rows of a range into ascending or descending order based on the values in specified columns. Before sorting a range of cells, consider these rules that NExS follows for sorting:

To sort a range of cells:

  1. Select Sort... from the Tools menu. NExS displays the Sort dialog box for you to enter the specifications of the sort. See Figure 9.2.

  2. Make the following entries in the Sort dialog box:
    Range -
    Type the addresses of opposite corners of the range to be sorted, separated by one or two periods (e.g. A1..D5) or use the mouse to select the range and paste it in with the middle mouse button. If you selected a range before choosing the Sort operation, NExS enters this range by default.
    Key 1 -
    Enter the address of a cell in the column on which to base the sort. For example, to sort by the contents of column B starting at row 2, enter B2. If you enter a range, NExS uses the leftmost column of the range.
    Key 2-5 -
    Enter the address of a cell on which to sort if two or more values in the primary column (specified by Key 1) are the same. Key N is significant only if the values in the columns specified by Key 1 through Key N-1 do not differentiate the rows being compared in the sort.

  3. Click on the check button labeled Descending to sort the column values in descending order. By default, NExS sorts in ascending order.

  4. Click off the check button labeled Update References if you do not want to update cell references once the sort is complete. By default NExS updates all cell references.

  5. Click OK or Apply to proceed. NExS sorts the cells and displays the results. Apply leaves the Sort dialog displayed on the screen.


Use the Undo Sort operation from the Edit menu to cancel the most recent sort operation. All cells are returned to their unsorted locations.

   figure3123
Figure 9.2: Sort Dialog Box


next up previous contents index
Next: 9.5 Extract Up: 9 Shortcuts and Tools Previous: 9.3 Goal Seek

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