Welcome to Excel Jet Consult. In this tutorial, we will learn how to achieve horizontal sorting of data in Excel. Let’s get started
In the caption below, we want to sort the Account Manager in Row 3 from A to Z
To sort the data horizontally, I selected the data from B3:O6
Execute: ALT + ASS to open the Custom Sort dialogue box
Un-check My data has headers
Click on Options and Sort left to right Orientation
Click OK
From the Sort by drop-down, select Row 3
Finally, click OK
From the caption below, we can see that the Account Manager has been horizontally sorted in alphabetically order.
