How to Swap Two Columns in Excel (Without Overwriting)
Swapping two columns by hand means cut, insert-cut-cells, and a shuffle — and one wrong paste drops a whole column on top of another. Here's why the manual way is fiddly, and the one-click way.
Last updated: August 2026
| Before | After | |
|---|---|---|
| A: City · B: Name | → | A: Name · B: City |
| contents exchanged in place, headers and all | ||
Why the manual swap is fiddly
Excel has no swap command, so the routine is: cut one column, use Insert Cut Cells to drop it beside the other, then shuffle the leftover column back into the gap. It's several steps, and if you paste onto occupied cells instead of inserting, one column overwrites the other and its data is gone — no warning. The safer temp-column route (copy A aside, move B into A, move the temp into B) works but adds even more steps to get wrong.
The 1-click way — Tellsheet's Swap Columns
Select the two columns and run Swap Columns. It exchanges their contents in place in a single step — headers and all — so the columns simply trade places with nothing overwritten and no temp column to manage. Every other column stays exactly where it was. Pairs with Reverse Order and Transpose.
Frequently asked questions
How do I swap two columns?
Select both columns and run Swap Columns — it exchanges their contents in place in one click, with nothing overwritten.
Why is cut-and-insert risky?
Paste onto occupied cells instead of using Insert Cut Cells and one column lands on the other, losing its data. It's also several easy-to-lose-track steps.
Does it swap the headers too?
Yes — the whole column content is exchanged, headers included, so you don't have to fix titles afterwards.
Do the columns stay put?
Yes — only the two you chose trade values; every other column keeps its position.
Related Excel guides
Swap two columns in one click
Swap Columns exchanges the contents of two columns in place — headers and all — with nothing overwritten.
Get Tellsheet free See pricing