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

Part 8. Working with Data Lists > Sorting Data List Records

Sorting Data List Records

Choose Data, Sort to open the Sort dialog box (the active cell must be somewhere in the data list on the worksheet).

Click the down arrow next to the Sort by field and choose from the list that appears. Then, click the corresponding Ascending option button to select it.

Click the down arrow next to the Then by field and choose from the list. Then, click the corresponding Ascending/Descending option and click OK.

Excel sorts the entire data list using the criteria you selected; for example, first by Region and then by Last Name within each region.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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