How to Sort Columns from Left to Right in Excel

This post will guide you how to sort columns from left to right in Excel. How do I sort rows horizontally from left to right in Excel.

You can use sort values in one column by using Sort command by default. Assuming that you have a list of data in range A1:E2, and you want to sort values in row 2 for multiple columns. How to sort values for multiple columns. You can use the following two methods to do it.

Sort Columns from Left to Right by Transpose function


#1 select the range of data and press Ctrl +C to copy it.

sort columns from left to right 1

#2 create a new worksheet in your current workbook, select one cell and right click on it, then select Paste Special from the popup menu list. And the Paste Special dialog will open.

sort columns from left to right2

#3 choose Transpose check box, click Ok button.

sort columns from left to right3

#4 you would notice that your data is presented in vertical form in the new worksheet.

sort columns from left to right4

#5 select range B2:B5 in column B, go to DATA tab, click Sort Smallest to Largest command under Sort& Filter group. And the selected values should be sorted in the order you like.

sort columns from left to right5

#6 select range A1:B5, and press Ctrl + C to copy it.

sort columns from left to right6

#7 back to your original sheet, and select the range A1:E2, and right click on it, select Paste special from the popup menu list, then select Transpose check box in the Paste Special dialog box. Click Ok button.

sort columns from left to right7

#8 you should see that the values from the multiple columns have been sorted.

sort columns from left to right8

Sort Columns from Left to Right by Using Sort Command


You can directly use Sort command to achieve the same result of sorting columns from left to right in Excel. Here are the steps:

#1 select the range of data that you want to sort, such as: B2:E2.

sort columns from left to right12

#2 go to DATA tab, click Sort command under Sort & Filter group. And the Sort dialog box will open.

sort columns from left to right9

#3 click Options button in the Sort dialog box, and select Sort left to right radio option in the Sort Options dialog box, click Ok button.

sort columns from left to right13

#4 select the row that you want to sort from Sort by drop down list. at this example, you need to choose Row2. And then click Ok button.

sort columns from left to right11

#5 you can see that the selected columns have been sorted from left to right.

sort columns from left to right10

 

You might also like:

Comments

So empty here ... leave a comment!

Leave a Reply

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

Sidebar