How to Move Multiple Columns in Excel (4 Quick Ways)

If you are looking for moving multiple columns to a different location in your Excel worksheet, then you have several ways to do this. In this article, you will learn 4 easy ways to move multiple columns in Excel.


Download Practice Book

Download the following Excel file for your practice.


4 Quick Ways to Move Multiple Columns in Excel

Let’s first introduce the dataset. We have the following dataset which contains 5 columns with headings. Our goal is to move columns to a different location in this table.

Move Multiple Columns in Excel (Sample Dataset)


1. Move Multiple Columns in Excel with Drag and Drop

It is the easiest way to move columns. Follow the steps below to learn this method quickly.

Steps:

  • Firstly, select the columns that you want to move to another location. Here, we have selected E4:F12. Hover over the selection. A 4-sided arrow appears.

Move Multiple Columns in Excel with Drag and Drop

  • Press and hold both the Shift key and the left mouse button.
  • Move the columns to the new location. Release both the left mouse button and the Shift key.

Finally, here is the result.

Move Multiple Columns in Excel with Drag and Drop (Result)

Read More: How to Move Columns in Excel (5 Quick Methods)


2. Shift Multiple Columns with Insert Cut Cells from Context Menu

This method is somewhat old-fashioned. Just follow the steps below to learn this quickly.

Steps:

  • Firstly, select the columns you want to shift → then Right-click your mouse → Click on the Cut command.

Move Multiple Columns in Excel with Insert Cut Cells

  • Now, select a column before where you want to insert the previously selected columns → again Right-click your mouse → and Click Insert Cut Cells option.

Move Multiple Columns in Excel with Insert Cut Cells

Finally, here is the result.

Read More: Excel VBA: Move Column Based on Header (3 Examples)


3. Move Multiple Columns in Excel Using Data Sort

You can move multiple columns by rearranging the order of all columns in one magic way. Just follow the steps below to learn this quick trick.

Steps:

  • In our dataset, In the blank Row 3, write down the order number in the way you want to rearrange your columns.  In this example, the rearrangement of the columns will be 1) ID, 2) Sales, 3) Salary, 4) First Name, and 5) Last Name. If your dataset doesn’t have any blank row, you can insert a new blank row.

Move Multiple Columns in Excel Using Data Sort

  •  Now, go to the Data tab > Sort. A Sort dialog box appears.

Move Multiple Columns in Excel Using Data Sort

  • Click on Options → Then Choose the Sort left to Right button → Finally, press OK.

  • From the Sort by drop-down list, select Row 1 and click OK.

  • Now, you can delete the Row which indicates the order number.

Finally, here is the result.

Move Multiple Columns in Excel Using Data Sort (Result)

Read More: How to Move Columns in Excel without Overwriting (3 Methods)


4. Move Multiple Columns in Excel Using SORT Function

The SORT function helps you rearrange the columns of your table in a new location while keeping the original table intact. Then, you can delete the old table if you are okay with your new table. Follow the steps below,

Steps:

  • Firstly, insert the numerical order in Row 3 in a way you would like to arrange the columns. You can do this by adding a new row if you have no blank rows.

  • Select the cell (In this example, Cell H3) where you want to locate your new rearranged table. And type the following formula in H3.
=SORT(B3:F12,1,1,TRUE)

Formula Explanation:

  • Firstly, insert your table range (in this example, B3:F12).
  • The sort_index is set to 1, which means the first row of the selected table (In this example, Row 3 of the entire worksheet) which we created to indicate the order number will be used as the sort_index.
  • The sort_order is set to 1, which means the data order will be ascending.
  • Finally, the by_column is set to true, which means we want to sort columns, not the rows.

Move Multiple Columns in Excel Using SORT Function

  • Press ENTER.

Here is the result.

Move Multiple Columns in Excel Using SORT Function (Result)

Read More: How to Move Columns in Excel Table (5 Methods)


Conclusion

In this tutorial, I have discussed 4 quick ways to move multiple columns in excel. I hope you found this article helpful. You can visit our website Exceldemy to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.


Related Article

Hafiz Islam
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo