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

Sorting a List

After you create your list, you'll want to view your information in different ways. Excel enables you to sort information in multiple ways and even create custom sorts. To sort a list or database, select the information and choose Data, Sort to open the Sort dialog box and specify your sort preferences (see Figure 18.7).

If you don't select anything before opening the Sort dialog box, Excel selects what it assumes is the list—all data contiguous to the active cell, minus the first row, which Excel assumes to be the header row. If your list contains possible blank lines or cells, select the list yourself before starting the sort process, or parts of the list may be excluded from the sort.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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