Free demo · Microsoft Excel · Lesson 7 · Basics · Sort and filter
Sort and filter a list with an Excel Table
Press Ctrl + T and a plain list becomes a Table: every heading gets an arrow that sorts and filters, and whole rows always stay together.
- 1Click any cell in the list, press Ctrl + T, then OK
- 2It is a Table now: banded rows and an arrow ▾ on every heading
- 3Arrow on Child › Sort A to Z: whole rows move together
- 4Arrow on Course: untick (Select All), tick Sport, OK
- 5Only the Sport rows stay. The others are hidden, not deleted
- ✓Table Design › Total Row adds up only the rows you see: 2,400