• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Chapter 37. Sorting Data

  • Ordering different types of data

    Excel orders and sorts different types of data using up to three fields at a time to determine the order.

  • Sorting a range or selected portion with as many rows or columns as desired

    You can sort the entire database range or any selected portion of the list range and you can also sort on more than three fields by performing several sorts in sequence.

  • Returning a range to its original sorted order

    If you have a need to sort the records in the list and then return them to the order they were entered, you can create a record index field to keep track of that order.

  • Using custom sort lists

    There are times when you need to sort a list using something other than the standard sort options. Excel allows you to sort based on a custom list.

  • Sorting columns

    Sorting is not only for rows; you can rearrange your columns as well.

Sorting organizes your data in either ascending or descending alphabetic and numeric order. Excel can sort the rows of a list or database, or the columns of a worksheet.

Excel sorts thousands of rows or columns in the time it would take you to manually sort just a few (sorting on three fields at a time in case duplicates exist in one of the sorted fields).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint