Moving a column in Excel takes three steps: select the entire column, cut or copy it, then insert it where you want it

The fastest way is to right-click the column letter, choose Cut, then right-click where you want it and choose Insert Cut Cells. This shifts everything over and closes the gap left behind. If you want to copy the column instead of moving it, use Copy and Insert Copied Cells — this leaves the original in place.

You can also drag a column to a new spot without cutting and pasting. Click and hold on the column letter, then drag it left or right to the position you want. Release the mouse button when you see the thick black line appear between the columns where you want it to land. This method works well when you can see both the starting and ending positions on your screen at the same time.

Key Takeaways

  • Right-click the column letter and select Cut, then right-click the destination column and select Insert Cut Cells to move a column and close the gap it leaves behind.
  • Use Copy instead of Cut if you want to keep the original column in place and create a duplicate elsewhere.
  • Dragging a column by its letter works when both the start and end positions are visible on your screen.
  • Moving a column shifts all the data in that column together — formulas that reference the column will update automatically.

Select the entire column by clicking its letter

Click on the column letter at the top of the spreadsheet — the gray box that says A, B, C, and so on. The entire column highlights in blue, showing that every cell from row 1 to the bottom of your data is selected. This is different from clicking a single cell, which selects only that one box.

If you need to move multiple columns at once, click the first column letter, then hold Shift and click the last column letter you want to include. All the columns between them will highlight together. You can then cut or move them as a group.

Cut the column so it moves instead of copies

Right-click on the selected column letter and choose Cut from the menu that appears. You will see a moving dotted border (called a marching ants border) around the column, which tells you it is ready to be moved. The data stays visible but is marked for removal from this location.

If you use Copy instead, the column will be duplicated rather than moved — the original stays where it is, and a copy appears in the new location. Choose Cut when you want to relocate the column, and Copy when you want to keep it in both places.

Right-click the destination and choose Insert Cut Cells

Click on the column letter where you want the moved column to appear. Right-click that column letter and select Insert Cut Cells. Excel will move your column to that position and shift the other columns over to make room. The dotted border disappears, and the move is complete.

The column that was in your destination position slides to the right, along with everything to its right. If you had data in column D and you inserted a cut column there, column D becomes column E, column E becomes column F, and so on. Nothing is deleted — everything just shifts over.

Drag a column when you can see both positions

Position your mouse pointer on the column letter you want to move. Click and hold down the mouse button, then drag left or right across the column headers. As you drag, you will see a thick black vertical line appear between columns, showing where the column will land when you release.

Drag until the black line is between the column you want on the left and the column you want on the right. Release the mouse button, and the column moves to that spot. This method is faster than cut-and-paste when both the source and destination are visible, but it does not work well if you need to move a column far to the left or right and have to scroll to see the destination.

Understand what happens to formulas when you move a column

If other cells contain formulas that reference the column you moved, those formulas update automatically. For example, if cell E5 contains the formula =SUM(A:A) and you move column A to become column C, the formula in E5 changes to =SUM(C:C). Excel tracks the column by its contents, not by its letter position.

This automatic updating is one reason to move columns rather than delete and re-enter them. When you move a column, all the connections stay intact. If you delete a column and create a new one elsewhere, formulas that referenced the old column will show an error.

Use the undo button if you move a column to the wrong spot

If you move a column and realize it should go somewhere else, press Ctrl+Z on Windows or Command+Z on Mac to undo the move. The column returns to its original position. You can undo multiple times to step back through several actions if needed.

The undo button is also in the top left corner of Excel, showing a curved arrow pointing left. Click it to undo your last action. If you undo too far and want to redo what you just undid, press Ctrl+Y (Windows) or Command+Y (Mac), or click the redo button next to the undo button.

Frequently Asked Questions

Can I move a column to the very beginning or very end of the spreadsheet?

Yes. To move a column to the beginning, right-click it, choose Cut, then right-click column A and choose Insert Cut Cells. To move it to the end, cut the column and then click the first empty column letter to the right of your data, right-click, and choose Insert Cut Cells.

What is the difference between moving and copying a column?

Cut removes the column from its original location and places it elsewhere. Copy leaves the column where it is and creates an identical copy in the new location. Use Cut to relocate, and Copy to duplicate.

If I move a column, do the row numbers change?

No. Moving a column only changes which column letter it occupies — it does not affect rows at all. Row 1 stays row 1, row 2 stays row 2, and so on. Only the column letters shift when you move columns around.

Can I move a column if it contains formulas?

Yes. When you move a column with formulas, the formulas move with it. Any other formulas that reference the moved column update automatically to point to its new location, so your calculations stay correct.

What happens if I move a column and then realize I made a mistake?

Press Ctrl+Z (Windows) or Command+Z (Mac) to undo the move. The column returns to where it was. You can undo multiple times if you need to step back through several actions.