Home -> Sort & Filter

Sorting Data

The Movie table is alphabetical by title. How many movies are dramas? thrillers? Rock musicals? You can sort the table by genre.

 

Try it: Sort by Genre

Select the Genre column

Look on the label for the Sort tool. Choose Sort Z-A.

 

This Movie table has one Western and many rows of Dramas.

 

If you repeat the sort going A-Z, you will find many records which do not have a genre listed. These records are incomplete: all of the information hasn’t been added yet.

 

Memo to Self: Microsoft always sorts Null fields first, (empty cells), then numbers, and then text data.