Move and insert an Excel column (quickly)

Have you ever needed to move AND insert an Excel column quickly. If you are trying to move it to a place that already has information you first need to insert a column otherwise it wants to overwrite the information. The place it moved from will also have a blank column which you may want to delete.

How to do a ‘Normal’ move column in Excel

Very simple.

  1. Highlight a column
  2. Move your cursor to the edge of the column until it turns into a compass (see below)
  3. Left click and hold
  4. Drag to where you want it to go.

Move and insert an Excel column

It will warn you if the column is going to overwrite some other column of data. It will also leave a blank column behind.

How to move and insert an Excel column in one go

Just as easy. Do exactly as above but instead of a left click, use a right click when you are going to drag it to the new column. So the steps are:

  1. Highlight a column
  2. Move your cursor to the edge of the column until it turns into a compass
  3. Right click and hold
  4. Drag to where you want it to go.

When you let go you will receive the following options

Move and insert an Excel column

Choose the Shift Right and Move option.

You will see that

  • all the columns shift right
  • the column you moved is placed in the correct place
  • the column that it came from is removed.