Goal
You’ll be able to sort and filter data correctly, and understand a genuinely important risk specific to sorting: accidentally sorting only part of your data, breaking the relationship between rows.
Learn
Sorting reorders rows based on the values in one or more columns — Data tab → Sort, or the quick A-Z/Z-A buttons for a single-column sort. Filtering temporarily hides rows that don’t match a chosen condition, without actually deleting or reordering anything — Data tab → Filter adds dropdown arrows to your column headers, letting you choose exactly which values to show.
Here’s a genuinely important risk specific to sorting: if you select only one column before sorting (rather than your whole data table), Excel may sort just that column, while every other column’s data stays in its original row order — completely destroying the correct relationship between, say, a person’s name and their actual score, since the names and scores would no longer line up correctly.
Excel usually detects this risk and shows a warning dialog (“Sort Warning: Excel found data next to your selection…”) asking whether to expand the selection to include the whole table, or continue sorting just what you selected. The safe answer is almost always to expand the selection, unless you have a specific, deliberate reason not to.
Filtering is generally safer in this respect, since it only hides rows, never reorders or separates columns from each other — the underlying data relationships stay intact regardless of which filter conditions you apply.
Decision Task
You select only the “Score” column (not the whole table) and click Sort, and Excel shows a warning asking whether to expand your selection. Before reading on: what would happen if you chose “Continue with the current selection” instead of expanding it, given a table with names next to those scores?
Show Answer
Only the Score column would be reordered, while the Name column (and any other columns) would stay in their original row order — meaning each name would now be sitting next to a completely different, wrong score than the one that actually belonged to them. This is exactly the “broken row relationship” risk this lesson warns about, and expanding the selection would have correctly kept each name paired with its own actual score.
Common Mistake
Sorting just one selected column without expanding to include the rest of the related data, especially when Excel’s own warning dialog specifically asks about this. Dismissing or ignoring that warning without understanding what it’s actually protecting against is exactly how names, IDs, or dates end up silently mismatched with the wrong corresponding data after a sort.
Practice Questions
1. What’s the fundamental difference between sorting and filtering?
Show Answer
Sorting reorders rows based on column values; filtering temporarily hides non-matching rows without reordering or deleting anything.
2. Why does Excel show a warning dialog when you try to sort just one selected column in a larger table?
Show Answer
To warn that sorting only that column risks breaking the correct row-to-row relationship with the rest of the table’s data, since only the selected column would be reordered.
3. Does filtering ever permanently delete the hidden rows’ data?
Show Answer
No — filtering only temporarily hides rows that don’t match the chosen condition; the data itself remains completely intact and can be shown again by adjusting or clearing the filter.
4. True or False: it’s always safe to sort just one column in isolation, regardless of what other data is next to it.
Show Answer
False — this is exactly the risk this lesson covers; sorting one column in isolation can break the correct pairing with adjacent related data.
5. What should you generally choose when Excel’s sort warning asks whether to expand your selection?
Show Answer
Expand the selection, unless you have a specific, deliberate reason to sort only the originally selected column in isolation.
Try It Yourself
Without looking back, explain in your own words why filtering is generally considered a “safer” operation than sorting, in terms of the specific risk this lesson covered.
Show Answer
Filtering only hides rows that don’t match a condition, without ever reordering or separating any data from its correct row — so there’s no risk of breaking the relationship between a name and its corresponding score, the specific risk that sorting an incomplete selection can cause.
Quick Check
1. What does sorting do to your data?
Show Answer
Reorders rows based on the values in one or more chosen columns.
2. What does filtering do to your data?
Show Answer
Temporarily hides rows that don’t match a chosen condition, without deleting or reordering anything.
3. What real risk does sorting only part of a table (not the whole thing) create?
Show Answer
It can break the correct relationship between columns, since only the selected column gets reordered while the rest stays in its original position.
4. What should you generally do when Excel’s sort warning dialog appears?
Show Answer
Choose to expand the selection to include the whole related table, in almost all normal cases.
5. Where do you find the Filter option in the ribbon?
Show Answer
The Data tab.