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

Sorting a List

You can sort a list by the values in one or more columns. Excel allows you to sort on the basis of the contents of a single column or multiple columns. When sorting on multiple columns, each additional column serves as a tie-breaker. For instance, you could sort on State and on Zip Code. This would group each state's records together, while breaking them into subgroups for each zip code.

To perform a simple sort

Do one of the following:

  • Click any cell within the column on which you want to sort. Click the Sort Ascending or Sort Descending icon on the Standard toolbar (Figure 12.13).

    Figure 12.13. The Standard toolbar has icons that you can click to perform an ascending or descending sort.


  • With AutoFilter enabled, click the AutoFilter arrows beside the column on which you want to sort. Choose Sort Ascending or Sort Descending from the drop-down menu (see Figure 12.12).

The list rows are rearranged.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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