Sorting and filtering answer two different questions. Sorting changes the order of records. Filtering temporarily hides records that do not meet your criteria. Both are essential for working with large Excel lists.
Before you sort
Make sure the data has clear column headers and that the rows represent complete records. If you sort only one column in a multi-column table, you can separate values from the records they belong to.
Sort text, numbers or dates
Select a cell in the dataset and use the Sort & Filter controls. You can sort text alphabetically, numbers from smallest to largest, or dates chronologically. For more complex sorting, use a custom sort with multiple levels.
Example: sort sales by region and amount
Suppose a sales table contains Region, Salesperson and Amount. A custom sort can place regions together and then order the sales within each region by amount.
This is more useful than sorting the Amount column alone because each complete sales record stays together.
Filter a dataset
Filtering lets you display only rows that meet a condition. For example, show only the North region, orders above $1,000, or records from a particular month.
Use multiple filters
You can filter more than one column. For example, show rows where Region is North and Status is Pending. The visible result is the intersection of the selected criteria.
Filter dates
Excel provides date-filter options such as periods and ranges. If the source dates do not behave like dates, check the underlying data type before troubleshooting the filter.
Sort by more than one column
Use a custom sort when you need a hierarchy, such as Department first, then Employee, then Date. The order of sort levels matters because later levels break ties created by earlier levels.
Common mistakes
- Sorting one column only: Keep the complete record together.
- Including blank or unrelated rows: Check that the intended dataset is selected.
- Dates stored as text: Text dates may sort alphabetically rather than chronologically.
- Forgetting an active filter: A filtered worksheet may hide records that are still present.
- Using color as the only data rule: Filtering and sorting should be based on the actual values whenever possible.
Sort and filter safely
- Confirm the headers and dataset boundaries.
- Make sure each row is a complete record.
- Save or duplicate important data before major sorting operations.
- Apply the sort or filter.
- Check a few records to confirm the result is what you intended.
- Clear filters when the hidden rows need to be visible again.
Quick answer
Use Sort when you need to change record order and Filter when you only need to display records matching certain conditions. Keep complete rows together and verify that dates and numbers are stored as the correct data types.
Related Excel guides
For controlled data entry, see How to Create a Drop-Down List in Excel. For data cleanup before sorting, see How to Clean Data in Excel. For summaries after filtering and sorting, see How to Create a PivotTable in Excel.
Related Excel guide: How to Use SORT in Excel.