In this lesson you will learn to sort data in Excel.

To learn how to sort data need data. Let's use the table below.

Excel sorting table

You need sorting because that's not look professionally. Sort sales descending.

Sorting starts marking data that you want to sort. In this case, select the range of cells A1: C11. Then go to the Data tab on the ribbon and press the Sort button. Dialog box appears.

Excel Sort dialog box

Choose sort by Sales order Largest to Smallest value. Don't forget to tick My data has headers check box.

Excel Sorting

You can also to add next level of sorting. Click Add LEvel and sort Regions alphabeticaly.

Excel Sort second level

Sorting finished. Well done!

Excel sorting done

Download sample spreadsheet for free.