Moving a column in Excel takes three clicks: right-click the column letter, choose Cut, then right-click where you want it and choose Insert Cut Cells

Excel does not have a dedicated "move" button. Instead, you cut the column and insert it in the new location, which shifts everything else over automatically. The process works the same way whether you are moving one column or several at once, and whether you are moving them left or right.

The reason this matters: if you try to drag a column header, Excel will only copy it, not move it. Cutting and inserting is the method that actually relocates the data and leaves no duplicate behind.

Key Takeaways

  • Right-click the column letter (A, B, C, and so on) at the top of the spreadsheet, not a cell inside the column.
  • Select Cut from the menu, then right-click the column letter where you want the data to go and select Insert Cut Cells.
  • To move multiple columns at once, click the first column letter, hold Shift, and click the last column letter, then cut and insert as normal.
  • Excel will shift all other columns automatically to fill the gap left behind.
  • If you make a mistake, press Ctrl+Z (or Cmd+Z on Mac) when ready to undo and restore the original layout.

Moving a single column step by step

Start by locating the column you want to move. Look at the very top of the spreadsheet where you see the column letters: A, B, C, D, and so on. Click on the letter itself — not on a cell in that column, but on the gray header where the letter appears. The entire column will highlight in blue, showing that it is selected.

Right-click on that same column letter. A menu will appear with several options. Find and click Cut. The column will now have a dotted border around it, which tells you it is ready to be moved. Do not click anywhere else or the cut will cancel.

Now click on the column letter where you want the data to go. For example, if you want to move column B to the position of column D, click on the D. Right-click on that column letter and select Insert Cut Cells. Excel will move your original column to that spot and shift the other columns to make room. The dotted border will disappear, and the move is complete.

Moving multiple columns at once

If you need to move several columns together, select them all before cutting. Click on the first column letter you want to move, then hold down the Shift key on your keyboard and click on the last column letter. All the columns between them will highlight in blue.

Right-click on any of the highlighted column letters and select Cut. The dotted border will appear around all of them. Then click on the column letter where you want them to start, right-click, and select Insert Cut Cells. All the columns will move together as a group.

What happens to the data when you move a column

When you move a column, all the data in that column moves with it — every number, every text entry, every formula. The column keeps its width and formatting. If other columns have formulas that refer to your moved column (like =SUM(B:B)), those formulas will automatically update to point to the new location.

The columns that were in the way shift over to fill the gap. If you move column B to where column D was, then the old columns C and D become the new columns B and C. This happens when ready and affects the entire spreadsheet.

Undoing a move if something goes wrong

If you move a column and realize it was a mistake, press Ctrl+Z on Windows or Cmd+Z on a Mac. Excel will undo the move and put everything back where it was. You can undo multiple times if you need to go back several steps.

This works even if you have already clicked elsewhere or done other work. However, if you close the spreadsheet without saving, you will lose the undo history. So if you are moving columns in an important file, it is worth taking a moment to check the result before you save.

Why you might want to rearrange columns

People usually move columns to group related information together or to put the most important data first. For example, you might move a "Total" column to the left so it appears right after the "Name" column, making the spreadsheet easier to scan. Or you might move a "Notes" column to the end so it does not interrupt the flow of numerical data.

Moving columns is also useful when you are combining data from two different spreadsheets and need to match the column order. Instead of retyping or copying data around, you can straightforward rearrange the columns to line up.

The difference between moving and copying

Moving removes the column from its original location. Copying leaves it where it is and creates a duplicate elsewhere. If you accidentally copy instead of cut, you will end up with two versions of the same column, which usually is not what you want.

To copy a column instead, right-click and select Copy (not Cut), then right-click the destination and select Insert Copied Cells. The original column stays in place. You can then delete the original if you no longer need it, but that is an extra step.

Frequently Asked Questions

Can I move a column by dragging it?

Dragging a column header will copy it, not move it, leaving the original behind. Always use Cut and Insert Cut Cells instead to move a column without creating a duplicate.

What if I move a column and a formula breaks?

Most formulas update automatically when you move a column. If a formula shows an error after the move, press Ctrl+Z to undo, then check the formula to see if it was written in a way that does not update automatically. Formulas that use column letters (like =SUM(B:B)) update; formulas that use cell ranges sometimes do not.

Can I move a column to a different sheet?

No, cut and insert only work within the same sheet. To move a column to a different sheet, copy it, go to the other sheet, and paste it there, then delete the original from the first sheet.

Does moving a column change the order of my data rows?

No. Moving a column only changes which column is in which position. All the rows stay in the same order, and each row's data stays together.

What if I move a column by mistake and do not notice right away?

If you have not closed the file, press Ctrl+Z as many times as needed to undo back to the point before the move. If you have already saved and closed the file, you will need to manually move the column back or use the file's version history if your system keeps one.