How to Sort in Excel

How to Sort Data in Excel

Excel Training

Excel Training Features:

  • Interactive bite-sized lessons

  • Get Certified

  • Accurate skill assessments

  • Customizable, LMS-ready content

Prices
Users love us
4.9 stars out of 5 on G2

4.9 out of 5 on G2

How to Sort in Excel

In Excel, you can take tables or ranges of data and sort them into different orders. For example, you can sort text alphabetically; numbers by size; dates and times chronologically; cells or fonts by color or icon; or you can create a custom sort. Usually you sort by column, but you can also sort by row.

Sort by One Column

  1. Select a cell in the column you want to sort.
  2. Click the Sort & Filter button on the Home tab.
  3. Select a sort order.
    • Sort A to Z: Sorts the column in ascending order.
    • Sort Z to A: Sorts the column in descending order.
    • Custom Sort: Allows you to specify custom criteria, such as multi-level data sorting.
    Sort Data

    You can also right-click the cell and select Sort.

Sort by Multiple Columns

If you want to sort by more than one column, you need to use a custom sort. For example, you can sort first by the last name column, then by first name. That way, all the Andersons will be listed before the Bakers, and Andy Anderson will come before Bill Anderson.

  1. Click the Sort & Filter button on the Home tab.
  2. Select Custom Sort.
    Sort Data

    The Sort dialog box appears.

  3. Select the first column you want to sort by.

    To sort by cell or font color, or by icon, click the Sort On list arrow and select an option.

  4. Select a sort order.

    The options for the Order change depending on what you choose for the Sort by variable.

  5. To sort by an additional column, click the Add Level button.
    Sort Data
  6. Select the next column you want to sort by.
  7. Select a sort order.

    Repeat these steps as necessary to sort by additional columns.

  8. Click OK.
    Sort Data