Sorting puts a list in order — A to Z, smallest to largest, oldest to newest. It takes one click, but there is one habit that keeps it safe. This page covers both, so you never end up with names attached to the wrong numbers.
A list you can order is a list you can actually use. Sort surnames A to Z and you can find someone by eye. Sort a column of costs largest to smallest and the three things worth worrying about float to the top. Nothing is added or removed by sorting — the same rows are simply rearranged.
- Selecting only this column is the danger
- Click one cell inside the list instead
- The header row becomes the labels
When you click one cell and sort, Excel looks around, works out where your list starts and stops, treats the top row as headings, and moves whole rows together. Names stay with their own numbers.
Try it yourself
In A1 type Name and in B1 type Cost. Fill three rows underneath, for example Smith 40, Adams 90, Baker 15.
The top row becomes your headings, which is what lets Excel label the sort options with real words instead of "Column A".
Click once on any single cell inside that block, such as A3.
This tells Excel which list you mean without you selecting anything. One cell is enough.
On the Data tab, click Sort A to Z.
Excel sorts by the column your cursor is in — the names — and carries each cost along with its name. Adams, Baker, Smith.
Click a cell in the Cost column and click Sort Largest to Smallest.
Same list, different question. 90, 40, 15, with the right name still beside each figure.
Press Ctrl and Z together.
Undo reverses a sort completely. Knowing this makes sorting safe to experiment with.
Words people use
Check yourself
If you can say yes to each of these, you are ready for the next lesson.
- I click one cell inside a list before sorting, never a lone column
- I can sort text A to Z and numbers largest to smallest
- I know that Ctrl and Z undoes a sort
- I know where to go to sort by two columns at once