How to sort columns left to right in Excel
To sort columns horizontally in Excel, select the range and go to Data → Sort → Options → Sort left to right. Excel reorders the columns within the selection using values from a row you choose. Include every cell that needs to move with each column.
Choose the range and sort row
Suppose the first row holds product names and the next rows contain unit prices and stock counts. Leave the labels in column A in place and select B1:D3. Sorting only the names would leave prices and counts behind, breaking their association with the products.
Unhide any relevant rows or columns so you can review the range. Test on a copy if you need the original layout. The menu steps below refer to desktop Excel for Windows.
Sort from left to right
- Select all cells that must move together, such as B1:D3. On the Data tab, open Sort and select Options.
- Choose Sort left to right under Orientation, then select OK. The Sort by menu now lets you choose a row.
- Choose Row 1 as the sort key, Cell Values as the criterion, and ascending order, then select OK. To sort by price instead, use Row 2.
Check the result with an example
Keep the field labels in the first column and select the three product columns in the example. Sorting by name changes C, A, B to A, B, C.
| Product | C | A | B |
|---|---|---|---|
| Unit price | 30 | 10 | 20 |
| Stock | 6 | 12 | 9 |
From left to right, the prices should now read 10, 20, 30 and the stock counts 12, 9, 6. Check that product A still has price 10 and stock 12. That pairing is a quick check on the selected range.
What to check if sorting goes wrong
If the left-to-right option is unavailable, check whether the selection is an Excel table. Tables do not support horizontal sorting. If you need this sort, work on a copy converted to a normal range.
If 2 and 10 appear out of order in a numeric sort, check whether either is stored as text. If products and values are mismatched, use Ctrl+Z immediately and check the selection and sort row.



