How to sort data on a table worksheet

You sort worksheet data to arrange it for more effective analysis. For example, you might want to sort a list of sales figures numerically so that you analyze the relative standing of sales people.

To sort data on a table worksheet:

1. Display the worksheet that you want to sort.

2. Choose Tools | Sort to display the "Edit Worksheet dialog: Sort tab".

   
   Description of the illustration st.gif
   
   

   The Sort Table dialog displays current sort options in a sort list.

3. Click Add to add a new row to the sort list and specify sorting options as required.

   Hint: You can also:

   • remove a sort item by selecting an item in the sort list and clicking Delete

   • rearrange the precedence of sort items by selecting an item in the sort list and clicking either Move Up or Move Down

4. Click OK to save the details and close the Sort dialog.

   Discoverer refreshes the worksheet according to the sort options that you select.

Notes

• You can also sort worksheet data by right-clicking on a worksheet item and selecting either Sort High to Low, Sort Low to High, or Group Sort.
  Description of the illustration sort_9.gif