In this tutorial, we will learn How to move a column in excel
You can use the Shift key with Mouse drag or use the Cut and Paste cells method to move columns in Excel. You also have the option to change the order of the Columns
How to move a column in excel: Step by Step Guide
Enclosed are the steps to move a column in Excel
Step 1: Select a Column
- Move your cursor on top of the Column which you want to move.
- You will notice the mouse cursor has been changed to an arrow.
- Now Click to Highlight the Column
Step 2: Navigate to the border of the Selected Column and you will get four direction sign arrows
Step 3: Now Press and hold the Shift key
Step 4: Now Click and Hold Click to the left or right border of the Column and start dragging it to the left or right
As you drag the column a dark border will appear which specifies where the new column will be moved.
Step 5. Move the Column as per your requirement
Step 6. Now you can release the Shift key and left mouse click button
How to move multiple columns in Excel without overwriting existing data
- Select the Columns which you want to move
For example click on the Column A ,then Press and hold the shift key and click on Column B
Now drag the Columns in the direction where you want to move as specified in previous steps .
Your multiple columns will be moved as shown below.
How to Move a Column in Excel using the Cut and Paste Method
Another method to move a column in excel is using the Cut and Paste Method
Step 1 : Click on the Column which you want to Move
Step 2 : Now Right Click using mouse and Select Cut from the drop-down
Step 3 : Now Click on the Column where you want to paste it.
Step 4 : Now right Click and Choose Insert Cut Cells
The column which you have cut will be moved infront of the cell where you have performed Insert Cut cells.
Similarly you can also move multiple rows or single rows.
How to Change the order of the Columns in Excel
Enclosed are the steps to change the order of the columns in excel
Step 1 : Click on the First row ,then right Click and Select Insert
Step 2 : Now in the first row specify the oder in which you want to display the Columns (Company name ,Laste name,Stage ,Value )
Step 3 : Now Select the Entire data and Click on Sort and Filter.
Once you have selected the entires columns,Go to the Top right quick access menu and Click on Sort & filter
Step 4 : From Sort & Filter drop-down Select “Custom Sort”
Now a Sort screen will pop-up
Step 5 : On the Sort Dialog box Click on Options.
Step 6. Choose Sort left to Right and then click on OK.
Step 7 : In Sort by Select “Row 1” from the drop-down and then press OK
Step 8. Now Delete the first Row which we have inserted in step 1
The order of the columns will be changed as shown below
We hope this tutorial on How to move a column in excel was helpful
Related articles :