Select the data you want to sort and open the Sort tool one of these ways:

• On the Home tab, select “Sort & Filter” in the Editing section of the ribbon. At the top of the pop-up box, choose “Sort A to Z” or “Sort Z to A.”
• On the Data tab, select “A – Z” or “Z – A” in the Sort section of the ribbon.

Your data is then sorted in the order you picked, either alphabetically from A to Z or the reverse. This option also sorts numbers the same way, from lowest to highest or the opposite.

You can also use the A to Z sorting when you create a custom sort which we’ll describe next.

Row Sorting

For more advanced options in Excel like sorting by row instead of column, you can create a custom sort.

Select your data, go to the Data tab, and click “Sort” in the Sort & Filter section of the ribbon. Then, click “Options” at the top of the Sort box.

In the small pop-up box, mark the Sort Left to Right option, check the box for Case Sensitive at the top if you like, and click “OK.”

You can then continue setting up your sort by row with the drop-down boxes. Depending on the options you pick in the first drop-down boxes, you’ll be able to sort from A to Z, top to bottom, or another option.

RELATED: How to Sort by Color in Microsoft Excel

Choose the following in the drop-down boxes:

• Sort by: Pick the column or row.
• Sort on: Pick either “Cell Color” or “Font Color” depending on what you want to sort. Then, use the additional box that appears to select the color.
• Order: Pick “On Top” or “On Bottom” per your preference.

Click “OK” when you finish, and you’ll see your data sorted by your chosen color.

Conditional Formatting Icon Sorting

RELATED: How to Use Icon Sets to Represent Values in Microsoft Excel

Choose the following in the drop-down boxes:

• Sort by: Pick the column or row.
• Sort on: Pick “Conditional Formatting Icon” and then use the additional box that appears to pick the icon.
• Order: Pick “On Top” or “On Bottom” per your preference.

Click “OK” when you finish, and you’ll see your data sorted by your chosen conditional formatting icon.

List Sorting

One convenient sorting option many don’t realize exists in Excel is list sorting. For instance, you may want to sort by day of the week or month of the year. Select your data and then “Sort” on the Data tab to open the Sort box.

Choose the following in the drop-down boxes:

• Sort by: Pick the column or row containing the list items.
• Sort on: Pick “Cell Values.”
• Order: Pick “Custom List.” Then choose an existing list in the Custom Lists section and click “OK.”

You’ll see the list appear in the Order drop-down menu in the Sort box. Click “OK” to sort your data by the list.

You’ll then see your data sorted by your chosen list.

RELATED: How to Create a Custom List in Microsoft Excel

Choose the following in the drop-down boxes:

• Sort by: Pick the column or row containing the list items.
• Sort on: Pick “Cell Values.”
• Order: Pick “Custom List.” Select “New List,” click “Add,” and then enter each list item in the List Entries box. Be sure to enter them in the order you want them. Click “OK” when you finish.

You’ll see the list in the Sort box’s Order drop-down menu. Click “OK” to sort your data by this list.

You’ll then have your data sorted by the new custom list you just created.

Multi-Level Sorting

RELATED: How to Use the Microsoft Excel SORT Function

In the Sort box, set up your first sort option with the drop-down boxes. Then, choose “Add Level” and set up the secondary sort you want to use.

Keep in mind that, Excel sorts your data based on this list of levels from top to bottom. So if needed, you can rearrange them. Select a level and then use the arrow buttons to move that level up or down.

When you finish, click “OK” to apply the sort for your multiple levels.

Sorting your data in Microsoft Excel helps you see it the way you need to for analysis or review. So keep these sorting methods in mind and also look at how to sort by date in Excel.