Sort and Filter Lists

Excel icon

Download this .pdf tutorial and learn to use lists to find the information you’re looking for.


Inside this course:

Excel is an excellent number cruncher, but it's also great for creating and managing lists. You can track everything from e-mail addresses to inventory items in a list, but for lists to be useful, you need to be able to quickly find the information that you're looking for.

Before you begin
1. Prepare your worksheet
2. Sort information in a list
3. Sort by several columns at once
4. Filter a list
5. Filter by custom criteria
6. Reset filters
Quick Reference Card

Practice file

Tutorial lessons are designed to be viewed in order. Download and use this practice file for hands-on experience while taking the tutorial.

Excel practice file SortFilterLists.xlsx (92 KB)

More courses available at Microsoft Office Training.

Applies To: Excel for Mac 2011

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language