Quick start: Sort data in a worksheet

When you sort information in a worksheet, you can see data the way you want and 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?

Icon image

Select the data that you want to sort    

  • Select a range of data, such as A1:L5 (multiple rows and columns) or C1:C80 (a single column). The range can include titles (headers) that you create to identify columns or rows.

Selected data

Icon image

Sort quickly    

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

  2. Click Button Image to perform an ascending sort (A to Z or smallest number to largest).

    quick sort buttons in the sort and filter group on the data tab

  3. Click Button Image to perform a descending sort (Z to A or largest number to smallest).

Icon image

Sort by specifying criteria    

Use this technique to choose the column you want to sort, plus 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.

    Sort command in the Sort and Filter group on the Data tab

    The Sort dialog box appears.

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

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

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

More about sorting

Applies To: Excel 2013



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language