The fastest way to move a column

Right-click the column header letter (A, B, C, and so on) to select the entire column. A menu appears. Click Cut. Then right-click the column header where you want it to go, and click Insert Cut Cells. The column moves to that position, and all other columns shift to make room.

This method preserves formulas and keeps your data relationships intact. If you have a spreadsheet where column D contains totals that reference columns A, B, and C, moving column D will not break those references.

An alternative is to click and drag. Click the column header, hold down the mouse button, and drag left or right to the new position. A thick line appears between columns to show where it will land. Release the mouse. This works the same way as cut and insert, but some people find it harder to control precisely, especially in large spreadsheets.

Key Takeaways

  • Right-click a column header, choose Cut, then right-click where you want it and choose Insert Cut Cells to move the entire column without breaking formulas.
  • Dragging a column by its header letter also works, but the cut-and-insert method is more reliable in large spreadsheets.
  • Moving a column shifts all adjacent columns automatically — you do not have to move them separately.
  • If you copy instead of cut, Excel will ask whether you want to shift existing cells; use cut to avoid this extra step.

Moving multiple columns at once

Select more than one column by clicking the first column header, then holding Shift and clicking the last column header you want to move. All columns between them highlight. Right-click any of the selected headers and click Cut. Then right-click the destination column header and click Insert Cut Cells.

The columns move as a group and stay in the same order relative to each other. If you select columns B, C, and D, they will arrive at the destination in that same sequence.

What happens to formulas when you move a column

Formulas update automatically when you move a column using cut and insert. If a formula in column E says =SUM(A1:D1), and you move column B to a different location, the formula adjusts to account for the new positions. The sum still includes the same four columns — they are just in a different order on the screen.

This is why cut-and-insert is safer than copying and deleting. If you copy a column to a new spot and then delete the original, formulas that referenced the old position will break and show #REF! errors. Using cut-and-insert avoids this problem entirely.

Moving a column to the very beginning or end

To move a column to the far left (before column A), right-click the column header, click Cut, then right-click column A and click Insert Cut Cells. The column you cut becomes the new column A, and everything else shifts right.

To move a column to the far right, cut it and then right-click the first empty column after your data. If your data ends at column Z, right-click column AA and click Insert Cut Cells. The column lands at the end.

Undoing a move if you make a mistake

Press Ctrl+Z (Windows) or Command+Z (Mac) immediately after moving a column. Excel reverses the move and puts the column back where it was. You can undo multiple moves by pressing the shortcut several times.

If you have already saved the file after moving the column, undo will not work. In that case, you will need to move the column back manually using the same cut-and-insert method.

Why you might not want to move a column

In some spreadsheets, the column order matters for how the file is used elsewhere. If another program imports data from your spreadsheet in a specific order, or if other people have formulas that reference columns by letter, moving columns can break their work. Before you move a column in a shared file, check with anyone else who uses it.

A safer alternative is to insert a new column in the position you want, copy the data there, and delete the original column later. This takes more steps but gives you time to check that nothing broke before you commit to the change.

Frequently Asked Questions

Can I move a column in Excel Online?

Yes. Right-click the column header, click Cut, right-click the destination column, and click Insert Cut Cells. The process is identical to the desktop version of Excel. Dragging also works in Excel Online, though it can be slower depending on your internet connection.

What if I only want to move some cells in a column, not the whole column?

Select just the cells you want to move (not the entire column header). Right-click and click Cut. Click the cell where you want the data to start and right-click. Click Insert Cut Cells. Excel will ask which direction to shift the remaining cells — choose the option that makes sense for your layout.

Does moving a column change the order of rows?

No. Moving a column only changes the left-to-right order of columns. All rows stay in the same order from top to bottom. If row 5 is your data, it remains row 5 after you move any column.

Can I move a column to a different sheet?

Not directly with cut and insert. Instead, select the column, copy it, go to the other sheet, right-click a column header, and click Insert Cut Cells. Then return to the original sheet and delete the column if you no longer need it there.