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.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.