You can more easily organize and view data in Excel by sorting and filtering it.
You may use Excel to keep track of lists and other information, maybe people, products, expenses, bills, taxes, and more. But sometimes you need a way to sort and filter all the data in each spreadsheet so you can better arrange what you view or just peek at specific records. And that’s exactly what Excel offers: You can sort the data in each column alphabetically or numerically, from smallest to largest or largest to smallest. You can even add multiple levels to sort the data in more than one way.
If sorting doesn’t quite do the trick, you can filter the data. Filtering adds a dropdown menu to each column so that you can choose which data you want to see:
- You can choose to see data equal to, greater than, or less than a certain value.
- You can opt to see only records with blank fields.
- And you can adopt custom filters.
But figuring out how to use sorting and filtering properly can be a challenge unless you know your way around both features. Let’s look at the many ways to sort and filter your data in Excel.
For this article I’m using Excel 2016, but these sorting and filtering instructions work the same in prior versions of Excel as well.