Sort By Column/Rearrange Columns In Excel

Let’s see how to sort by column in excel. There are several instances when we require the data to be sorted on the basis of columns or swap the columns in excel sheet.

Below is the example which shows how to rearrange the columns in a quick way.

Capture

In the data, we would want to sort the columns in the order specified by the numbers highlighted in yellow i.e. 1(Credit Card Product) should appear first and then 2(Limit) should appear second and so on.




Step 1

Select the data and go to filter, alternatively you could use the filter shortcut Alt+D+S.

Capture

Step 2

Now go to Options

Capture

Step 3

Now select the “Sort left to right” and click OK.

Capture

Step 4




Now select Row 1 from the Sort By box as we want our columns to rearrange by the order specified in the row 1 and click OK.

Capture

Capture

As you could see the columns are rearranged in a quick manner.

Hope this helped.

Share The Knowledge

Random Posts

  • Generate Random Date In Excel

    Let’s see how to generate a list of random date between two dates in excel. We will write a simple […]

    Share The Knowledge
  • Extract Substring Between Parenthesis In Excel

    get substring between the bracket in excel, excel formula to get value from within parenthesis, get numeric value from inside bracket in excel, get data from within bracket in excel

    Share The Knowledge
  • Return Font Name And Font Size In VBA

    return font size i excel return font name inn excel, vba to find font size, vba to find font name, get font size in excel, get font name in excel

    Share The Knowledge
  • Delete Row Based On A Substring In Excel

    delete row in excel based on some string, excel delete rows based on substring, delete data in excel based on certain string, excel delete rows if the cell has certain string

    Share The Knowledge

Leave a Reply