Cloud Training (Online)




How to Move Columns in Excel ?

Microsoft Excel provides a shortcut for the users to move columns in excel using two different ways – using Shift Key and using Insert Cut Cells option. These options lets the excel users to change the order of the columns quickly.

Using Shift Key in Excel

You can use the shift key when moving the column so that you don’t overwrite the data in the excel worksheet. Follow the below steps to move the columns using shift key in excel.

  1. Select a column that you wish to be moved . For example , Column C.
How to Move Columns in Excel ?
  1. Mouse Hover the border of the selelcted column (Ef : column C). This will display a four directional arrow .
  2. Press and hold the SHIFT key and then move the column to the new position (Eg : Before column B).
  3. Release the mouse button and the shift key.

You should see that the column C is moved.


How to Move Columns in Excel ?
  1. You can easily move multiple columns by clicking and dragging the column headers to the new position. You can perform the same steps as earlier (2-4) to move multiple columns in columns without overwriting the data.

Using Insert Cut Cells in Excel

One of the other ways to move the columns in excel is using the Insert Cut Cells.

  1. Select a column that you wish to move (Eg : column C ) in the example above.
  2. Use the shortcut key CTRL + X to cut the entire column.
  3. Select the column before which the new cut column will be inserted.
  4. Right click and then click “Insert Cut Cells”.
How to Move Columns in Excel ?

The result is the column being moved.

How to Move Columns in Excel ?