Excel Column Sorting Drop-Down: How to Use It

In Excel for Microsoft 365 on Windows, click the arrow in a column header and choose Sort A to Z or Sort Z to A to sort that column; for numbers or dates, Excel shows equivalent ascending or descending choices. If the arrow is missing, select your data and choose Data > Filter, or turn the range into a table with Insert > Table.

What the column drop-down does

The small arrow beside a column heading is the AutoFilter drop-down. It lets you sort the records by that column and, separately, filter the records to show only values that match conditions you choose. Sorting changes the order of rows; filtering hides rows that do not match. The two actions share a menu, which is why the control is sometimes called a sort drop-down even though it can do more than sort.

For a text column, the menu normally offers Sort A to Z and Sort Z to A. A column Excel recognizes as numeric offers smallest-to-largest and largest-to-smallest choices; a date column offers oldest-to-newest and newest-to-oldest. The exact wording depends on the data type Excel detects. Sorting does not remove records: it rearranges them so the values in the chosen column appear in the selected order.

When you apply a filter, the arrow may change to a funnel icon, indicating that the column is currently filtered. A funnel is not a different kind of sort control. Open it to review or clear that column’s filter, or use the sorting choices in the same menu.

How to show the drop-down arrows

For an ordinary data range, click a cell in the range and select Data > Filter. Excel adds a drop-down arrow to each header in the detected range. If you want to use a keyboard shortcut on Windows, press Ctrl+Shift+L to toggle AutoFilter on or off. On a Mac, use the ribbon’s Data > Filter command if the shortcut differs in your Excel version or keyboard settings; Excel for the web also provides Filter on the Data tab.

If you are creating a new list, a table is often more convenient:

Select the range, including its column headings.
Choose Insert > Table.
Check My table has headers if the first row contains names such as Date, Product, or Amount, then select OK.

Excel tables include filter arrows in their header row and generally expand when you add data directly below them. If a table already exists but the arrows are not visible, click inside it and look for the filter-button setting on the Table Design tab. A normal filtered range can also have its arrows turned off and on with Data > Filter.

Use meaningful, unique headings rather than leaving the header row blank. Excel needs to identify the top row as headings so it can keep those labels above the data while sorting. If your selection has no header row, Excel may treat its first row as a record instead.

Sort a column without separating its records

To perform a basic sort, open the arrow for the column you want to use and choose the ascending or descending command. For example, suppose a worksheet has columns named Customer, Region, and Order Date. Choosing A to Z on Region arranges the records by region while keeping each customer and order date on the same row. The other columns move with their record; they are not independently sorted.

That row relationship is essential. Avoid selecting just the cells in one column and sorting them by themselves when the values belong to records in adjacent columns. If Excel detects that other cells contain related data, it may ask whether to expand the selection. Choose Expand the selection so the complete rows move together. Sorting only the selected column can mismatch names, dates, and amounts, creating errors that are difficult to spot.

Before sorting, check that the data is arranged as a single rectangular list: one header row, one record per row, and no completely blank row or column breaking the list. A blank row can cause Excel to detect only part of the data. If the records are in a table, click within the table before sorting; the table boundary helps Excel keep the operation within the intended data.

Sort by more than one column

A header arrow is ideal for a quick, single-column sort. To specify a primary and secondary order, use Data > Sort. In the Sort dialog, select the first column under Sort by, choose what to sort on (usually Cell Values), and select an order. Choose Add Level to add another column. Excel applies the first level, then orders matching values by the next level.

For example, to list orders by Region and then by Order Date, sort first by Region from A to Z, add a level for Order Date, and choose oldest to newest. Orders within each region will then appear in date order. If you instead put Order Date first, the date becomes the primary grouping and Region only orders records that share a date.

The Sort dialog can also sort by cell color, font color, or a conditional-formatting icon when those choices apply to the selected data. A custom list can be useful when ordinary alphabetical order is not appropriate—for example, sorting weekdays Monday through Sunday rather than alphabetically. Use Data > Sort, choose the relevant sort order option, and select or create a custom list where available.

Sorting, filtering, and the Sort button compared

The header arrow, the Filter command, and the Sort command are related but serve different purposes:

Header drop-down: quickly sorts one column or filters its values.
Data > Filter: turns the header arrows on or off for a range; it is not itself an instruction to reorder rows.
Data > Sort: opens controls for multiple sort levels, sort-on options, and more detailed ordering.

Filtering does not delete the hidden records. For instance, filtering a Status column to show only “Open” hides other statuses from view, but clearing the filter restores them. Sorting, by contrast, changes the sequence of visible records. If a filter is active, Excel sorts the displayed records and keeps excluded records hidden until the filter is cleared.

Common problems and reliable fixes

No arrow appears: Click inside the data and choose Data > Filter. For a table, check that its filter buttons are enabled on the Table Design tab. Confirm that the first row is intended to be headers.
Only part of the list sorts: Look for blank rows or columns splitting the data, and make sure the sort selection includes all record columns. Converting a well-formed list to a table can make its boundaries clearer.
Numbers or dates sort strangely: Some entries may be stored as text while others are real numbers or dates. A value that looks like 1,200 but is text may sort differently from a numeric 1200. Check cell formats and the underlying values; applying a number or date format alone does not always convert text into a true number or date.
Names appear in an unexpected order: Leading spaces, inconsistent spelling, or a mixture of text and numbers can affect ordering. Clean the source values when appropriate, then sort again. For a special order such as priority levels, use a custom list rather than expecting alphabetical order to understand the intended ranking.
Excel asks whether to expand the selection: Choose Expand the selection when neighboring columns belong to the same records. Choose to continue with the current selection only when you genuinely intend to sort those cells independently.

Another common misconception is that the arrow belongs to only one column. When AutoFilter is enabled for a range or table, each header has its own menu, and you can sort by any one of those fields. You do not need to move the column to the left edge first.

Undoing a sort and keeping the original order

Press Ctrl+Z on Windows immediately after a sort to undo it. On Mac, the usual undo shortcut is Command+Z. However, once other edits have been made, or after closing and reopening the workbook, undo may not be a dependable way to restore the previous order. Excel does not automatically keep a separate record of the original row sequence.

If you may need to return to the source order, add an index column before sorting. Fill it with 1, 2, 3, and so on, then sort by another field as needed. To restore the original sequence, sort by the index column. This is especially useful when reviewing a list that will be sorted repeatedly or shared with other people.

Frequently Asked Questions

How do I add a sort drop-down to one Excel column?
Select a cell in the data and choose Data > Filter. Excel adds arrows to the header row across the detected range, not just the one column. For a table, create it with Insert > Table and include a header row.

Can I sort one column without moving the other columns?
You can, but it is usually unsafe when rows represent related records. Sorting one field independently can attach values to the wrong names or dates. Keep the complete records together and choose Expand the selection if Excel offers that prompt.

Why does my Excel sort arrow show Filter options?
The header arrow opens the AutoFilter menu, which combines sorting and filtering. Choose a sort command to reorder the rows, or select and clear filter criteria to show records again. A funnel icon signals that a filter is active.

Can I sort by two columns using the drop-down?
The arrow menu is best for one-column sorting. For a primary and secondary sort, choose Data > Sort, set the first level, then select Add Level and specify the next column.

How do I get the original order back after sorting?
Use Undo right away with Ctrl+Z on Windows or Command+Z on Mac. For a reliable way to restore the order later, add a numbered index column before sorting and sort by that column when you need the original sequence.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.