Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

When sorting information in a worksheet, you can rearrange the data to find values quickly. You can sort a range or table of data on one or more columns of data. For example, you can sort employees —first by department, and then by last name.

How to sort in Excel?

Icon image

Select the data to sort    

Select a range of tabular data, such as A1:L5 (multiple rows and columns) or C1:C80 (a single column). The range can include the first row of headings that identify each column.

Example of selected data to sort in Excel
 

Icon image

Sort quickly and easily    

  1. Select a single cell in the column you want to sort.

  2. On the Data tab, in the Sort & Filter group, click A to Z command in Excel that sorts A to Z or smallest number to largest to perform an ascending sort (from A to Z, or smallest number to largest).

    Sort buttons in the Sort & Filter group on the Data tab in Excel

  3. Click Z to A command in Excel that sorts Z to A or largest number to smallest to perform a descending sort (from Z to A, or largest number to smallest).

Sort by specifying criteria    

Use this technique to choose the column you want to sort, together with other criteria such as font or cell colors.

  1. Select a single cell anywhere in the range that you want to sort.

  2. On the Data tab, in the Sort & Filter group, click Sort to display the Sort popup window.

     

    Sort command in the Sort & Filter group on the Data tab in Excel

  3. In the Sort by dropdown list, select the first column on which you want to sort.

  4. In the Sort On list, choose Values, Cell Color, Font Color, or Cell Icon.

  5. In the Order list, choose the order that you want to apply to the sort operation—alphabetically or numerically, ascending or descending (that is, from A to Z (or Z to A) for text, or lower to higher, or higher to lower for numbers).

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×