Excel – Sorting Data
- Sort data alphabetically in an Excel worksheet
- Sort data numerically in an Excel worksheet
Sort data alphabetically
First, we need some data to work with.
- 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.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 | Sort 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.Top 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.