How to move a column in excel ( Quick & Easy Guide )

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
How to move a column in excel

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 .

How to use Column and Columns Formu...
How to use Column and Columns Formula in Excel | Excel Tutorial For Beginners | Lesson - 21

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 :

How to Convert Kg to Lbs in Excel and Google Sheets ( Easy Guide )

How to Import Excel Sheet into Notion: Easy Guide ( less than 10 seconds)