Sorting Lists

The Excel sort function is useful for rearranging data. When working in Excel sorting data can quickly reorganize content too.

Introduction

By the end of this module, you should be able to:

Sorting lists

Sorting lists is a common spreadsheet task that allows you to easily reorder your data. The most common type of sorting is alphabetical ordering, which you can do in ascending or descending order.

In this example, we will alphabetize employee names.

To sort in ascending or descending order:

null To sort in reverse alphabetical order from Z to A, select Descending.

To sort multiple categories:

Challenge!

If you have not already done so in a previous challenge, download and save the Employee Sales spreadsheet.