Excel Horizontal Sort – Re arrange columns

Excel Horizontal Sort – Re arrange columns

Use this function with caution. Moving cells from the same row away from each other may be an undesirable side effect of sorting by one column.

 

We're here to meet you everyone. Using the example given below, I'll show you how to re-arrange columns in a horizontal orientation in this tutorial:

Example:

Excel Horizontal Sort – Re arrange columns01

Tax Returns and Government Filings often need you to change the system data to reflect the data. Because of this, columns in the system don't line up with government regulations, which is an issue.

 

Such in order to meet the government's standards, I'll teach you how to re-arrange columns in Excel so that the columns fit the sequence. To use it, simply follow the procedures outlined below:

1: To begin, if you use numbers in the upper row, it signifies that you wish to order the columns from the first to the last.

Excel Horizontal Sort – Re arrange columns02

This only has to be done once because the data you receive at the end of the month will be the same every time ERP generates a Data Report.

2: Select a Table that includes the quantity of cells you need.

Excel Horizontal Sort – Re arrange columns03

3: Click the Sort Button on the Data Tab.

Excel Horizontal Sort – Re arrange columns04

4: Click on the Options button in the Sort Panel that pops up.

Excel Horizontal Sort – Re arrange columns05

5: To sort left to right, select the "Sort left to right" option in the Options Button Panel and press OK.

Excel Horizontal Sort – Re arrange columns06

Note: Using the Sort left to right option implies reordering the columns from left to right in accordance with the order in which they were entered.

6: Select the following items from the Sort Panel:

a: In the Sort by option, select the row number in which you applied the sequence from the drop-down menu.

Excel Horizontal Sort – Re arrange columns06

b: In the Order drop-down menu, the Smallest to Largest option is selected to build the column according to the numerical sequence specified.

Excel Horizontal Sort – Re arrange columns08

7: The final step is to click on OK and Excel will re-arrange your columns for you.

Excel Horizontal Sort – Re arrange columns09

Enjoyed this article? Stay informed by joining our newsletter!

Comments

You must be logged in to post a comment.

About Author