Office Settings & Configuration

Fix Excel Multi-Level Sorting When Only Column A Appears

Phi Hung VoPhi Hung Vo Nov 18, 2026 869 views

Question details

The user needs to sort Excel data by multiple columns or sort a selected range without affecting unrelated rows.

Fix Excel Multi-Level Sorting When Only Column A Appears
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the data

On the worksheet, select the full data range, including its headers and every column that should move with each row.

2
Open the Sort dialog

Go to Data > Sort. If prompted, choose Expand the selection so related columns stay together.

3
Check the orientation and headers

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.

4
Add sort levels

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.

Select the full data range and add sort levels
Keep rows aligned: Include all related columns in the selection. Sorting one column independently can separate its values from the rest of each record.
Free Microsoft Office alternative

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.

Sort spreadsheet data by selected columnsCompatible with Microsoft Excel XLS and XLSX filesFamiliar spreadsheet interface for an easier transitionFree and lightweight office suite
microsoft office alternative - wps office

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.