Thinkabara

📗 Excel for Beginners · Lesson 8 of 10

Sort a table

Google Classroom

How to sort a table in Excel from high to low and in alphabetical order, without mixing up the rows.

The tasks in this lesson

1. The leaderboard

  1. Click any cell in the Points column
  2. Click "Sort high to low"

💡 Excel sorts the whole table together, so the names move with the points.

2. Alphabetical order

  1. Click a cell in the Player column
  2. Click "Sort A→Z / low to high"

💡 The header row does not move when you sort.

All lessons

  1. ✍️ 1. Typing in cellsCells, typing, fixing and deleting
  2. 🎨 2. Format a tableSelect a range, bold and dollar format
  3. 🧮 3. Your first formulaMultiply, add and subtract between cells
  4. ➕ 4. SUM and AVERAGEThe total and the average of a column
  5. ⬇️ 5. Drag and fillThe fill handle, and $ to lock a cell
  6. 🔢 6. MAX, MIN and COUNTThe most, the least, and how many filled in
  7. 🔀 7. IF: if... then...Pass or fail, and COUNTIF
  8. ↕️ 8. Sort a tableHigh to low, and alphabetical
  9. 📊 9. Your first chartA bar chart and a pie chart
  10. 🏠 10. Project: a family budgetEverything we learned in one sheet