Sorting Data

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

Sorting levels

If you need more control over how your data is sorted, you can add multiple levels to any sort. This allows you to sort your data by more than one column.

To add a level:

In our example below, we'll sort the worksheet by Homeroom Number (column A), then by Last Name (column C).

  1. Select a cell in the column you want to sort by. In our example, we'll select cell A2.
    Screenshot of Excel 2013Selecting cell A2
  2. Click the Data tab, then select the Sort command.
    Screenshot of Excel 2013Clicking the Sort command
  3. The Sort dialog box will appear. Select the first column you want to sort by. In this example, we will sort by Homeroom # (column A).
  4. Click Add Level to add another column to sort by.
    Screenshot of Excel 2013Clicking Add Level
  5. Select the next column you want to sort by, then click OK. In our example, we'll sort by Last Name (column C).

    Screenshot of Excel 2013Sorting by Homeroom # and Last Name
  6. The worksheet will be sorted according to the selected order. In our example, the homeroom numbers are sorted numerically. Within each homeroom, students are sorted alphabetically by last name.
    Screenshot of Excel 2013The worksheet sorted by homeroom number and last name

If you need to change the order of a multilevel sort, it's easy to control which column is sorted first. Simply select the desired column, then click the Move Up or Move Down arrow to adjust its priority.

Screenshot of Excel 2013Changing the sorting priority for a column