How to Move Columns in Excel Table (5 Methods)

Get FREE Advanced Excel Exercises with Solutions!

If you want to move columns in Excel Table, this article is for you. Here, we will demonstrate to you 5 easy and effective methods that will help you to move columns in Excel tables.


How to Move Columns in Excel Table: 5 Quick Methods

The following table shows Last Name, First Name, Salary and Department columns. We want to move columns in this table using 5 methods. Here, we used Excel 365. You can use any available Excel Version.

How to Move Columns in Excel Table


Method-1: Using SHIFT Key to Move a Single Column in Excel Table

Here, we will use the SHIFT key to move the First Name which is column C to the left of Column B.

➤ First of all, we will select the First Name column.

How to Move Columns in Excel Table

➤ After that, we will hover the mouse cursor over the selected border.

We will see that a four-sided arrow appears.

➤ Now, we will Press and hold the SHIFT key on the keyboard.

➤ We will click and hold the left mouse button.

Now, it’s time to move the column to the new position.

Here, the new position is at column B, and we can see a green border at column B.

Also, we can see B:B written sign which indicates that the First Name column will be moved to B.

➤ Now, we will release the left mouse button.

➤ And we have to release the SHIFT key.

Finally, we can see that the First Name Column is moved left.

How to Move Columns in Excel Table

Read More: How to Move Columns in Excel without Overwriting


Method-2: Using SHIFT Key to Move Multiple Columns in Table

In this method, we want to shift both the Salary and the Department column to columns B and C positions.

➤ At first, we have to select the Salary and Department columns.

How to Move Columns in Excel Table

➤ After that, we will hover the mouse cursor over the selected border.

We will see that a four-sided arrow appears.

➤ Now, we will Press and hold the SHIFT key on the keyboard.

➤ We will click and hold the left mouse button.

Now, it’s time to move the columns to the new position.

Here, the new position is at columns B and C, and we can see a green border at columns B and C.

Also, we can see B:C written sign which indicates that the Salary and Department columns will be moved to B and C.

➤ Now, we will release the left mouse button.

➤ And we have to release the SHIFT key.

Finally, we can see that the Salary and Department columns are moved to columns B and C respectively.

How to Move Columns in Excel Table


Method-3: Using Insert Cut Cells

In this method, we want the First Name column at column B, and we will use the Insert Cut Cells option for this.

➤ To begin with, we will select First Name.

➤ Now, we will right click on the mouse, and we will select the Cut option.

Now, we have to select the column in which we want to insert the column First Name.

➤ Here, we want the First Name column at Column B, therefore, we selected column B.

➤ After that, we right click on Column B, and we select the Insert Cut Cells option.

Finally, we can see the column First Name is moved to column B.

How to Move Columns in Excel Table


Method-4: Sort Option to Move Columns

In this method, we will sort the columns from left to right.

How to Move Columns in Excel Table

➤ First, we will select the entire table.

➤ Then, we will go to the Home tab in the ribbon, and we will select the Editing option.

➤ After that, we will select the Sort & Filter option, and select Custom sort.

A Sort window will appear.

➤ We will click on Options.

➤ Now, we will select Sort left to right, and click OK.

➤ After that, in the Sort by box, we will select Row 2.

➤ Click OK.

Finally, we can see that the columns in the table are sorted from left to right.

How to Move Columns in Excel Table


Method-5: Delete a Column to Move Column Left

In this method, we want to delete the column Last Name. this will automatically move the columns toward the left.

➤ First, we have to select the column Last Name.

➤ After that, we will right click on the mouse. A context menu will appear.

➤ We will click on the Delete option.

Finally, we can see that, all the movement of columns towards the left.

How to Move Columns in Excel Table


Download Practice Workbook


Conclusion

Here, we tried to show you some easy and effective methods that will help you to move columns in Excel Table. We hope you will find this article helpful. If you have any queries or suggestions, please feel free to contact us in the comment section.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Afia Kona
Afia Kona

Hello, I am Afia Aziz Kona. I graduated in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology (BUET). I have an immense interest in technical writing and content development, therefore, I am working as a content developer at Exceldemy. In my spare time, I travel, watch movies, and cook different dishes.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo