Move Columns

 

To quickly move columns in Excel without overwriting existing data, press and hold the shift key on your keyboard.

1. First, select a column.

Select Column

2. Hover over the border of the selection. A four-sided arrow appears.

Four-sided Arrow

3. Press and hold the Shift key on your keyboard.

4. Click and hold the left mouse button.

Click and Hold the Left Mouse Button

5. Move the column to the new position.

Move Column

6. Release the left mouse button.

7. Release the shift key.

Result:

Moved Column in Excel

To move multiple columns in Excel without overwriting existing data.

8. First, select multiple columns by clicking and dragging over the column headers.

Select Multiple Columns

9. Repeat steps 2-7.

Result:

Moved Columns in Excel

Note: in a similar way, you can move a single row or multiple rows in Excel without overwriting existing data.