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

Sorting a List

After you create a 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.10).

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 might be excluded from the sort. Individual blank cells will not cause Excel to exclude data. Data gets excluded when the entire list is broken up by a row and/or a column of blank cells.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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