Sorting Data

You can change the order of data in a spreadsheet by sorting it; for example, to arrange a list of items and its corresponding data in alphabetical order.

1. Select all of the cells you want to sort , as shown in Figure 20-16.

   Figure 20-16. Examples of sorted data

   

2. Choose Data > Sort.

3. In the Sort window, set the sort options you want. Use Figure 20-17 for guidance.

   Figure 20-17. Sorting data, Sort Criteria tab

   

4. Click the Options tab and make entries; use Figure 20-18 for guidance.

   Figure 20-18. Sorting data, Options tab

   

5. Click OK.

Be sure to select all the cells you want included in the sort. Any cells that aren't selected aren't included in the sort, which could throw your data off quite a bit.

Note

You can also use sort buttons on the toolbar for quick sorting in ascending or descending order.