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.
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.
➤ 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.
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.
➤ 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.
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.
Method-4: Sort Option to Move Columns
In this method, we will sort the columns from left to right.
➤ 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.
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.
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
<< Go Back to Move Columns | Columns in Excel | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!
