• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 28. Managing Information in Lists > Sorting Lists and Other Ranges

Sorting Lists and Other Ranges

Excel provides numerous ways to sort worksheet ranges. You can sort by columns or rows, in ascending or descending order, and with capitalization considered or ignored. (When you sort by rows, the rows of your list are rearranged, and the columns remain in the same order. When you sort by columns, the opposite kind of rearrangement occurs.) You can even define custom sorting sequences so that, for example, your company's division names always appear in a particular order, regardless of their alphabetic sequence.

Sorting on a Single Column

To sort on a single column—the Last Name column in Figure 28-1, for example—select one cell anywhere within that column. Then click either the Sort Ascending button on the Standard toolbar (to arrange the column in ascending numeric or alphabetic order) or the Sort Descending button (to do the opposite). Excel sorts in the order you want on the column in which the selection resides.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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