Move Columns

To move columns in Excel, use the shift key or use Insert Cut Cells. You can also change the order of all columns in one magic move.

Your Exercise

Please download here

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

1. First, select a column.

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

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

4. Click and hold the left mouse button.

5. Move the column to the new position.

6. Release the left mouse button.

7. Release the shift key.

Result:

To move multiple columns in Excel without overwriting existing data.

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

9. Repeat steps 2-7.

Result:

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

If you prefer the old-fashioned way, execute the following steps.

1. First, select a column.

2. Right click, and then click Cut.

3. Select a column. The column will be inserted before the selected column.

4. Right click, and then click Insert Cut Cells.

Result:

Note: in a similar way, you can move multiple columns, a single row or multiple rows.

Finally, you can change the order of all columns in one magic move. Are you ready?

1. Select row 1.

2. Right click, and then click Insert.

3. Use the first row to indicate the new order of the columns (Sales, Quarter, Country, Last Name).

4. Select the data.

5. On the Data tab, in the Sort & Filter group, click Sort.

The Sort dialog box appears.

6. Click Options.

7. Click Sort left to Right and click OK.

8. Select Row 1 from the 'Sort by' drop-down list and click OK.

9. Delete row 1.

Result:

Note: this technique is pretty impressive if you need to rearrange the order of many columns.

Google Sites

Report abuse