Sorting and filtering are among the most frequently used spreadsheet operations. They let you reorder data, find subsets, and focus on the records that matter for a given task. Used carefully, they are powerful. Used carelessly, they can corrupt your data.
Sorting
Sorting reorders rows based on the values in one or more columns. You can sort in ascending order (A to Z, smallest to largest, oldest to newest) or descending order (Z to A, largest to smallest, newest to oldest).
Multi-column sorting lets you sort by a primary column first, then by a secondary column for rows where the primary values are equal. For example, sort by province first, then by city within each province.
One of the most damaging spreadsheet mistakes is sorting a single column without including the rest of the data. If you sort only column A while columns B through F stay in their original order, you will disconnect names from their associated data — creating a corrupted dataset that may be impossible to recover. Always select the entire data range, or use your software's built-in sort feature that automatically includes all columns.
Filtering
Filtering hides rows that do not meet a condition, letting you work with a subset of your data without deleting anything. Common filter operations include:
- Showing only rows where a column equals a specific value
- Showing rows where a number is above or below a threshold
- Showing rows where a text field contains a specific word
- Showing rows where a date falls within a range
Structured Tables
Many spreadsheet applications let you define a data range as a structured table. Structured tables offer several advantages:
- Headers stay connected to data when sorting or filtering
- New rows added at the bottom are automatically included in the table range
- Formulas that reference the table update automatically as data grows
- Visual formatting makes the data range clear
Important Habits
- Recognize hidden rows. When a filter is active, some rows are hidden — not deleted. Calculations on a filtered range may include or exclude hidden rows depending on the function used. Be aware of this when summing or counting filtered data.
- Clear filters before sharing. If you share a filtered spreadsheet, the recipient may not realize that rows are hidden. Clear filters before distributing data.
- Copy filtered results carefully. When you copy and paste filtered data, verify that you are copying only the visible rows, not hidden rows as well.
- Keep source data intact. Sorting and filtering do not modify your data, but copying and pasting results into a new location does. Always preserve the original dataset.
Common Mistakes
- Sorting a single column without the rest of the record (data corruption)
- Forgetting that a filter is active and treating filtered results as the complete dataset
- Deleting rows that appear empty after filtering, not realizing they contain data for other filter conditions
Key Takeaways
- Always sort the entire record — never a single column in isolation.
- Filtering hides rows; it does not delete them.
- Clear filters before sharing or distributing data.
- Structured tables keep headers connected to data and simplify range management.
- spreadsheet sorting and filtering
- spreadsheet structured table
- spreadsheet filter hidden rows