Excel – Sorting Data

Backarrw

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.

image

Save your Planet worksheet.

Top of Page

Sort data alphabetically.We need to list the planets in alphabetical order.Select the data we want to sort.In this case we will select A4 through D8Note: 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.)Choose Data | Sortimage Select Column A and Ascending for A to Z-or-Select Column A and Descending for Z to A.Click OKYour sheet will look like the one shown below.imageTop of PageSort data by distance.We need to sort the data in descending sequence by distance from earth.Select the data we want to sort.In this case we will select A4 through D8
(Click cell A4, then, while holding down the Shift Key, click in cell D8.)
Choose Data | SortSelect Distance and DescendingClick OKYour sheet will look like the one shown below.image