Sort and Filter Lists


Excel-ikon 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-øvelsesfil SortFilterLists.xlsx (92 KB)

More courses available at Microsoft Office Training.


Udvid dine Office-færdigheder
Gå på opdagelse i kurser
Få nye funktioner først
Bliv Office Insider

Var disse oplysninger nyttige?

Tak for din feedback!

Tak for din feedback! Det lyder, som om det vil kunne hjælpe, hvis du bliver sat i forbindelse med en af vores Office-supportteknikere.