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

Sorting

You can sort lists by any column(s). Excel will quickly put database information in the order you specify.

To sort a list

1.
Select any cell in the list.

2.
Choose Data > Sort (Figure 9) to display the Sort dialog box (Figure 41).

Figure 41. The Sort dialog box, with a primary and secondary sort set up.


3.
Choose a primary sort field from the Sort By pop-up menu (Figure 42).

Figure 42. The Sort by (or Then by) pop-up menu lists all database fields.


4.
Select a sort order radio button:

  • Ascending is lowest to highest.

  • Descending is highest to lowest.

5.
If desired, repeat steps 3 and 4 for a secondary and tertiary sort field using options in the Then by areas.

6.
If the list has column titles, select the Header row radio button; otherwise, select the No header row radio button.

7.
Click OK. Excel sorts the list as you specified (Figure 43).

Figure 43. The beginning of a list sorted as shown in Figure 41.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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