How To Horizontally Sort Data In Excel

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.

Posted in Blog and tagged , , , .

Leave a Reply

Your email address will not be published. Required fields are marked *