Sort by Cell color
Excel Tips and Tricks

Quick Re-Arrange Columns Sequence Using Data Sorting

In this article, you will learn how to sort the data by columns. If you have multiple columns in your excel sheet and you want to arrange the order of the columns according to your requirement then you can use this trick.

Let’s say we have below given data.

Data set
Data set

Now we want the arrange the columns according to our requirements.

  • Insert a row above headers and put the numbers for each header.
Insert row and put column numbers
Insert row and put column numbers
  • Select the entire data.
  • Go to Data tab click on Sort.
  • The below-given window will be opened.
Sort window
Sort window
  • Click on the Options button.
  • Sort Options window will be opened.
  • Select the option “Sort left to right
  • Click on OK.
Sort Options window
Sort Options window
  • Select Sort by Row 1
  • Click on OK.
Sort Window
Sort Window

Your columns will be re-arranged Now you can remove the first row.

Columns re-arranged
Columns re-arranged

 

Using the same method, you can arrange the column by Cell colors or custom list also.

Sort by Cell background color
Sort by Cell background color

 

Click here to download the Practice file-

Watch the step by step video tutorial:

PK
My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 10 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.
https://www.pk-anexcelexpert.com