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

    graphics/20fig16.gif

  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

    graphics/20fig17.jpg

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

    Figure 20-18. Sorting data, Options tab

    graphics/20fig18.jpg

  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.




OpenOffice. org 1.0 Resource Kit
OpenOffice.Org 1.0 Resource Kit
ISBN: 0131407457
EAN: 2147483647
Year: 2005
Pages: 407

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net