Lesson 8: Sort a table
- Click any cell in the Points column
- Click "Sort high to low"
| A | B | |
|---|---|---|
| 1 | Player | Points |
| 2 | Alex | 12 |
| 3 | Bella | 30 |
| 4 | Dan | 7 |
| 5 | Emma | 21 |
| 6 | Finn | 18 |
| 7 | Grace | 25 |
- Sorted by points, high to low, and every name stays with its points
All lessons
✍️ 1. Typing in cells
Cells, typing, fixing and deleting🎨 2. Format a table
Select a range, bold and dollar format🧮 3. Your first formula
Multiply, add and subtract between cells➕ 4. SUM and AVERAGE
The total and the average of a column⬇️ 5. Drag and fill
The fill handle, and $ to lock a cell🔢 6. MAX, MIN and COUNT
The most, the least, and how many filled in🔀 7. IF: if... then...
Pass or fail, and COUNTIF↕️ 8. Sort a table
High to low, and alphabetical📊 9. Your first chart
A bar chart and a pie chart🏠 10. Project: a family budget
Everything we learned in one sheet
Cells, typing, fixing and deleting🎨 2. Format a table
Select a range, bold and dollar format🧮 3. Your first formula
Multiply, add and subtract between cells➕ 4. SUM and AVERAGE
The total and the average of a column⬇️ 5. Drag and fill
The fill handle, and $ to lock a cell🔢 6. MAX, MIN and COUNT
The most, the least, and how many filled in🔀 7. IF: if... then...
Pass or fail, and COUNTIF↕️ 8. Sort a table
High to low, and alphabetical📊 9. Your first chart
A bar chart and a pie chart🏠 10. Project: a family budget
Everything we learned in one sheet
How to sort a table in Excel from high to low and in alphabetical order, without mixing up the rows. Excel sorts the whole table together, so the names move with the points. The header row does not move when you sort.
Explore more: Excel course: all lessons, and Your first chart.