Sorting data (single and multi-level) in Excel - Step-by-Step Guide

Introduction

Sorting data helps you organize your spreadsheet so you can find information quickly. You can sort by one column or by multiple columns to arrange your data in the order you want.

When you want to list your sales from highest to lowest to see your best products

When you need to organize a contact list alphabetically by last name

When you want to sort a list of dates to find the earliest or latest event

When you want to sort by city and then by customer name within each city

When you want to group similar items together for easier analysis

Steps

Step 1: Select any cell in the column you want to sort

- Excel worksheet

Excel knows which column to sort

💡 Make sure your data has headers to keep them from moving

Step 2: Click the Data tab

- Ribbon at the top of Excel

Data tools appear below the ribbon

Step 3: Click Sort A to Z or Sort Z to A

- Sort & Filter group on the Data tab

The entire table sorts by the selected column in ascending or descending order

Step 4: Click Sort to open the Sort dialog box

- Sort & Filter group on the Data tab

Sort dialog box opens for multi-level sorting

Step 5: In the Sort dialog, under Column, select the first column to sort by

- Sort dialog box

First sorting level is set

Step 6: Choose Sort On (usually Values) and Order (A to Z or smallest to largest)

- Sort dialog box

Sorting order for the first column is set

Step 7: Click Add Level to add another sorting column

- Sort dialog box

A new row appears to set the second sorting level

Step 8: Select the second column and set Sort On and Order

- Sort dialog box

Second sorting level is set

Step 9: Repeat Add Level for more columns if needed

- Sort dialog box

Multiple sorting levels are set

Step 10: Click OK

- Sort dialog box

Data sorts by all selected columns in the order set

Before vs After

Before

A table with unsorted sales data: Product names and sales numbers in random order

After

The table sorted first by Product name alphabetically, then by Sales numbers from highest to lowest within each product

Settings Reference

Column

📍 Sort dialog box

Choose which column to sort by

Default: First column selected

Sort On

📍 Sort dialog box

Choose what part of the cell to sort by

Default: Values

Order

📍 Sort dialog box

Choose the sorting direction or custom order

Default: A to Z

Common Mistakes

Selecting only one column before sorting

Sorting one column alone breaks the data alignment and mixes rows incorrectly

Select any cell in the data range or the whole table before sorting so all rows move together

Not using the Sort dialog for multi-level sorting

Clicking only Sort A to Z sorts by one column and ignores others

Use the Sort dialog box to add multiple levels for sorting by more than one column

Summary

Sorting organizes your data by one or more columns to make it easier to read and analyze

Use the Data tab's Sort buttons for quick single-column sorting

Use the Sort dialog box to sort by multiple columns in the order you want