GCFLearnFree.org

Great information, simple language, and all for free.”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Excel 2013
  • Sorting Data

Excel 2013

Single page view print copy

Sorting Data

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 wish 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 wish 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 wish 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
previous next
previous 1 2 3 4 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.