Microsoft Office Tutorials and References
In Depth Information
Understanding data lists
Click the Sort by drop-down arrow, and select Year.
Click the Order drop-down arrow, and select Smallest to Largest; then click OK. Excel
sorts the list from the earliest to the most recent movie.
If you only want to sort the data in a single column, you can click any cell inside the column you
want to sort, and then in the Sort & Filter group, click either the Sort A to Z (
) or Sort Z to A
Sorting data on multiple i elds
Sometimes you need to sort on more than one i eld. In the best movies of all time
worksheet, you’ll sort by the director’s name and then the name of the movie.
In the excel0701_done worksheet, click the Most Popular tab located in the bottom-left
corner of the worksheet; click cell D2, and then in the Sort & Filter group, click Sort.
Excel displays the Sort dialog box.
Click the Sort by drop-down arrow, and then select Director.
The Sort by drop-down list displays the headings in the worksheet.