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

Sorting Lists

Excel's sorting capabilities let you view data in almost any order regardless of the order in which you entered it. To quickly sort a list, first click in the column by which you want to sort, and then click Sort Ascending. Excel selects all the data in your list and sorts it alphabetically, using the column that contains the active cell. Click Sort Descending to sort in reverse order, using the same column. If you want to sort only a portion of the list, make a selection first, and then use the Tab key to move the active cell to the correct column.

Tip

If the order in which you enter data is important, create a numeric field that you can use to identify each row, and then increment it by 1 for each new record. Re-sort using the values in this field to return the list to its original order. Don't use a formula for this field, however—when you sort the list, the values will change and you won't be able to return to the original sort order.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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