Fix Excel Multi-Level Sorting When Only Column A Appears
Question details
The user needs to sort Excel data by multiple columns or sort a selected range without affecting unrelated rows.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Using the Sort dialog to add multiple sort levels or sort a subset of a dataset.
- Observed behavior
- Only column A appears in the Sort dialog, additional sort levels cannot be added, or Excel sorts the entire dataset instead of the selected rows.
Check that each column you want to sort has a header and that you have selected all relevant columns. Click a cell in the data and look for the Table Design tab to see whether it is an Excel Table.
Select the full data range and add sort levels
Use this when the Sort dialog shows only column A or does not offer the columns you need.
On the worksheet, select the full data range, including its headers and every column that should move with each row.
Go to Data > Sort. If prompted, choose Expand the selection so related columns stay together.
In the Sort dialog, select My data has headers if your first row contains headers. Open Options and choose Sort top to bottom, then click OK.
Choose a column and sort order under Sort by, then click Add Level and choose the next column and order. Click OK to apply the sort.

Convert an Excel Table to a range before sorting selected rows
Use this when Excel sorts the entire table but you need to sort only a subset of its rows.
Sort Spreadsheet Data with WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and work with sorting tools to make moving your spreadsheet workflow easier.

Frequently Asked Questions
Why does Excel show only column A in the Sort dialog?
The selected range may include only column A. Select all columns you need, go to Data > Sort, and check Options to make sure Sort top to bottom is selected.
How do I sort by more than one column in Excel?
Select the full data range and open Data > Sort. Choose the first column, click Add Level, and choose each additional column and sort order.
Why does Excel sort my entire table?
Excel sorts the complete table to keep each row intact. If you need to sort only some rows, click the table and choose Table Design > Convert to Range, then select the relevant rows and related columns before sorting.
Can I sort one column without moving the other columns?
You can sort a single column in a normal range by selecting it and choosing Continue with the current selection when prompted. This can break the relationship between values in the same row, so use it only when the columns are independent.




