Excel - Sorting Data

Objectives:

1. Sort data alphabetically in an Excel worksheet
2. Sort data numerically in an Excel worksheet

Sort data alphabetically

First, we need some data to work with.

1. Create a new database like the one shown below.

Save your Planet worksheet.

Top of Page

Sort data alphabetically.

We need to list the planets in alphabetical order.

1. Select the data we want to sort.
1. In this case we will select A4 through D8.

Note: We do not just select the names. We need to select the data that goes with each planet.
(Click cell A4, then, while holding down the Shift Key, click in cell D8.)

2. Choose Data | Sort.

 

3. Select Column A and Ascending for A to Z

-or-

Select Column A and Descending for Z to A.

4. Click OK.

Top of Page

Sort data by distance.

We need to sort the data in descending sequence by distance from earth.

1. Select the data we want to sort.
1. In this case we will select A4 through D8.
   (Click cell A4, then, while holding down the Shift Key, click in cell D8.)