Horizontal sorting in Excel – Excel sorting is set to vertical orientation by default. However, you can also sort horizontally depending on your settings. Learn how to sort data horizontally in Excel using the advanced sort feature.
How to Sort Data Horizontally in Excel
Excel sorting is set to vertical orientation by default. However, you can also sort horizontally depending on your settings.
The data table below is not sorted by day of the week.
First, enter numbers above the data items. Use unique numbers in the order you want to sort horizontally.
Then use “CTRL+A” to select all data.
After selecting the data range, select the advanced sort feature.
By default, advanced sorting is set to sort vertically, as shown below.
Select Options, then choose the “Sort left to right” option as shown below.
Sort in ascending order based on the first row, where you entered the numbers for each item.
You have now sorted the data horizontally using Excel’s advanced sort feature.
When the process is complete, you will have sorted data as shown below.
Video Guide: How to Sort Data Horizontally in Excel
Conclusion
Excel has many small features that can greatly increase your productivity.
Check out the additional features below to get more out of Excel.