The fastest way to move a column

Right-click on the column letter at the top of the sheet. A menu appears with options including "Move column left" and "Move column right". Click the direction you want. The column slides into place when ready, and everything in it moves with it — formulas that reference that column update automatically.

This works whether you have one row of data or ten thousand. The column keeps its width, formatting, and all the data inside it. If you need to move a column more than one or two spaces, you can repeat this step as many times as needed, or use the method in the next section instead.

Key Takeaways

  • Right-click the column letter and choose "Move column left" or "Move column right" to shift a column one space at a time.
  • To move a column several spaces at once, cut the entire column, then right-click where you want it and paste it in place.
  • Any formula that refers to the moved column updates automatically — you do not have to rewrite it.
  • Moving a column is different from copying it; the original column disappears when you move it, but stays if you copy.

Moving a column multiple spaces at once

Click the column letter to select the entire column. The whole column highlights in blue. Then right-click and choose "Cut" from the menu.

Now click the column letter where you want the moved column to land. Right-click and choose "Insert 1 left" or "Insert 1 right" depending on which side of that column you want your data to appear. Then right-click again and choose "Paste". Your column appears in the new location, and the columns that were in the way shift over to make room.

This method is faster than clicking "Move column left" or "Move column right" repeatedly if you are moving something across five or more columns.

What happens to formulas when you move a column

If another cell contains a formula that points to the column you moved — for example, =SUM(C2:C100) — Google Sheets updates that formula automatically. The formula now points to wherever column C ended up. You do not have to find and fix these formulas yourself.

The one exception is if a formula uses an absolute reference, written with dollar signs like =SUM($C$2:$C$100). This formula still points to column C even after you move it, because the dollar signs tell Google Sheets "always use column C, no matter what". If you want the formula to follow the moved column instead, you would need to remove the dollar signs before moving.

Moving a column versus copying it

Moving a column removes it from its original location. Copying a column leaves the original in place and creates a duplicate somewhere else. To copy instead of move, select the column, right-click, and choose "Copy". Then click where you want the copy to go, right-click, and choose "Paste". Now you have the data in two places.

If you accidentally moved a column and meant to copy it, press Ctrl+Z (or Cmd+Z on Mac) to undo the move. The column returns to where it was, and you can try the copy method instead.

Undoing a move if something goes wrong

If you move a column and then realize it was the wrong choice, press Ctrl+Z on Windows or Cmd+Z on Mac. Google Sheets undoes the move and puts the column back where it started. You can undo multiple times if you need to — each press takes you back one step.

This works even if you have already moved other columns or made other changes. Google Sheets keeps a history of your recent actions, so you can step backward through them one at a time.

When moving columns is better than sorting

Moving a column is useful when you want to rearrange the order columns appear in without changing how the data is sorted. For example, if your sheet shows sales data with columns for Date, Product, Quantity, and Price, you might move Price next to Quantity so they sit side by side when you look at the sheet — but the rows stay in the same order.

Sorting, by contrast, rearranges the rows. If you sort by Price, the rows reorder from lowest to highest price, and all the columns move together. Use moving when you want to change the column order. Use sorting when you want to change the row order.

Frequently Asked Questions

Can I move multiple columns at the same time?

No, Google Sheets moves one column at a time. If you need to move several columns together, move them one by one in the order you want them to end up. It usually takes less than a minute for three or four columns.

What if I move a column and a formula breaks?

Formulas update automatically when you move a column, so they should not break. If a formula stops working after a move, undo the move with Ctrl+Z (or Cmd+Z on Mac) and check whether the formula uses absolute references with dollar signs. Those formulas point to a specific column no matter where it moves.

Does moving a column affect other people viewing the sheet?

If you are sharing the sheet with others, they see the column move happen in real time. If someone else is editing the sheet at the same time you move a column, Google Sheets handles the conflict automatically, though you may see a brief notification asking you to refresh.

Can I move a column to a different sheet?

No, moving only works within the same sheet. To move data to a different sheet, copy the column, switch to the other sheet, and paste it there. Then return to the original sheet and delete the column if you no longer need it.