Microsoft Works for Windows Spreadsheet Instructions

How Do I:
Sort a spreadsheet?

To Sort a Spreadsheet
                 CAUTION!!!  [Can separate data from labels if done incorrectly.]
This is NOT an essential skill for students. Only teach it when you have a special purpose because it can cause confusion for those who do not understand it well. 

1. Highlight the data to be sorted.  
2. On the Tools Menu, click Sort.
3. When the window below appears, select "Sort all the information" to keep the rows together.
4. If you want to sort columns individually, select "Sort only the highlighted information."
   

5. After making your choice, click OK, and then the next window appears.
   
   
   
   
6. Choose the column to sort by, choose ascending or descending order, and indicate whether or not you highlighted the header row.  If you choose Header row, the first row will be left out of the sort.  
7. If you choose Advanced, you will be given the option to sort by multiple columns.  The first choice is always the primary sort, but if there are duplicates in that column, it will sort by the second listed column, etc.

Last edited 6/4/01