How To Swap Columns in Excel

Last updated: August 20, 2026

Swapping columns is a common task, but a lot of people still do it the hard way by copying into a spare column, pasting back, and hoping nothing breaks. There are five faster methods, and the right one depends on how far apart the columns are and whether formulas point at them.

Which method should you use?

Method 1: How do you swap columns by dragging?

This is the fastest option when both columns are visible at the same time. The Shift key is what makes it a move rather than an overwrite.

Step 1: Select the column to move

Click the header of the column you want to move. To move column B, click the letter B at the top of the column. The whole column highlights.

Step 2: Grab the column border and hold Shift

Move the cursor to the edge of the selection until it becomes a four-sided arrow, then hold down Shift. Shift tells Excel to insert the column between two others rather than paste over whatever is already there.

Step 3: Drag the column to its new position

Still holding Shift, drag the selected column to where you want it. A vertical insertion line shows where it will land.

Release the mouse button first, and only then release Shift. Getting that order wrong is the single most common reason a drag turns into an overwrite and Excel asks whether you want to replace the contents of the destination cells.

Step 4: Verify the column position

Check that the column landed where you expected and that nothing was overwritten. If Excel asked you to confirm replacing cells at any point, press Ctrl + Z and start again, because that prompt means Shift was not held.

The rule: release the mouse before you release Shift. Do it the other way round and the drag becomes an overwrite.

Read more: How to use Excel for project management and tracking.

Method 2: How do you swap columns with Cut and Insert?

Use this when the two columns are far apart, when the sheet is too wide to drag across, or when you want no ambiguity about where the column lands. It is the most reliable of the three manual methods.

Step 1: Select the column to move

Click the header of the column you want to move. This example uses column C.

Step 2: Cut the selected column

Right-click the highlighted header and choose Cut, or press Ctrl + X. A dashed moving outline appears around the column to show it is on the clipboard.

Step 3: Insert the cut column at its destination

Right-click the header of the column that currently sits at the position you want the cut column to occupy, then choose Insert Cut Cells. Excel pushes that column and everything to its right one place further right, and drops your cut column into the gap.

So if you want the cut column to become the new column D, right-click column D. Do not right-click the column beside it. The column you click is the one that gets pushed aside, and the cut column takes its place.

Step 4: Verify the result

Confirm the columns are in the order you wanted and no data was lost. Because this is a cut rather than a copy, any formula elsewhere in the workbook that referenced the moved column now points at its new address automatically.

The rule: Insert Cut Cells inserts before the column you right-click, so click the destination column itself, not its neighbour.

Method 3: How do you swap columns with Copy and Paste Special?

This is the long way round, and it is worth knowing only for one specific case: when you want to move the values out of a column and deliberately leave its formulas behind. It uses a temporary parking column so nothing is overwritten before it has been saved somewhere.

Be clear about the trade-off before you start. Paste Special with Values selected strips formatting and formulas from what you paste. If you want to keep the source formatting, choose All in the Paste Special dialog instead of Values, or use Method 1 or Method 2, which preserve everything by design.

Step 1: Select and copy the first column

Click the header of the first column in the swap. To swap column A with column C, start with column A. Right-click and choose Copy, or press Ctrl + C.

Step 2: Paste it into a temporary column

Click an empty column well clear of your data, for example column H, and paste with Ctrl + V. Column H is now a safe copy of column A. Use the same letter for the rest of these steps.

Step 3: Copy the second column

Select the second column in the swap, column C in this example, and press Ctrl + C.

Step 4: Paste it over the first column

Go back to column A, right-click the header and choose Paste Special. Pick Values if you only want the data, or All if you want the formatting to travel with it, then click OK.

Step 5: Bring the parked column back and clean up

Go to column H, the temporary column holding the original column A. Copy it, go to column C, and use Paste Special with the same option you chose in step 4. Then delete column H so the sheet is clean.

The rule: if a copy and paste swap ever leaves you with only one copy of a column on screen, stop and press Ctrl + Z. The parked column is the whole safety net.

Method 4: How do you reorder many columns at once with Sort?

Dragging is fine for two columns. For fifteen columns that need to end up in a specific order, Excel can sort horizontally, which almost nobody knows it can do.

1. Insert a blank row above your header row.

2. In that new row, type the position number you want each column to end up in: 1 above the column that should be first, 2 above the column that should be second, and so on.

3. Select the whole block including the numbers row and the data, but not the row or column labels of the sheet itself.

4. Go to Data, then Sort.

5. Click Options, choose Sort left to right, then click OK.

6. In the "Sort by" dropdown, pick the row that holds your numbers, set the order to Smallest to Largest, and click OK.

7. Delete the helper row.

Every column moves to its numbered position in one action. This is the method to reach for when a report has to be rebuilt into a fixed column order every month.

One warning: sorting moves values, not structure. Formulas that reference cells by address will point at the wrong data afterwards. Convert formulas to values first, or use Power Query instead.

Method 5: How do you reorder columns in Power Query?

If the reorder has to happen every time the data refreshes, do it once in Power Query and never think about it again.

1. Click anywhere in your data and press Ctrl + T to turn it into a table, then click OK.

2. Go to Data, then From Table/Range. The Power Query Editor opens.

3. Drag a column header left or right to its new position, or right-click the header and use Move, then Left, Right, To Beginning or To End.

4. Click Close & Load.

The reorder is saved as a step in the query. Refresh the query next month against new data and the columns come out in the same order every time. Our guide to Power Query in Excel covers the rest of the editor.

How do you swap columns without a mouse?

Every step below is keyboard only, which matters if you are working on a laptop trackpad or cannot drag reliably.

1. Put the cursor anywhere in the column you want to move and press Ctrl + Space to select the entire column.

2. Press Ctrl + X to cut it.

3. Move to the destination column with the arrow keys and press Ctrl + Space again to select it.

4. Press Ctrl + Shift + Plus to run Insert Cut Cells.

That last shortcut only performs an insert-and-shift when there is cut content on the clipboard. With nothing cut, it inserts blank cells instead, so do not skip step 2.

The rule: Ctrl + Space selects a column, Ctrl + Shift + Space selects the whole data region, and Shift + Space selects a row.

What happens to your formulas when you swap columns?

This is where a column swap goes wrong quietly, so it is worth understanding before you touch a live model.

The rule: moving a column is safe, overwriting one is not. VLOOKUP is the exception that breaks silently either way, because it counts positions rather than following references.

Why is drag and drop not working?

Microsoft's reference on moving or copying cells and cell contents documents the Shift behaviour and the Insert Cut Cells command.

How do you swap columns inside an Excel Table?

An Excel Table, the kind you create with Ctrl + T, behaves differently and is actually easier.

• Click the table's own header cell for the column you want to move, so the column highlights inside the table.

• Drag it left or right by that header. No Shift key needed, because a Table already knows you mean to reorder rather than overwrite.

• Structured references such as =SUM(Table1[Revenue]) follow the column by name, so they keep working no matter where the column ends up. This is the strongest practical argument for using Tables in the first place.

If Excel refuses and says the operation is attempting to shift cells in a table, you are selecting whole worksheet columns rather than the table's columns. Click inside the table first.

How do you swap rows or individual cells?

The same two mechanics apply, turned ninety degrees.

• To swap two rows: click the row number to select the row, hold Shift, drag the row border up or down, and release the mouse before Shift. Or select the row, press Ctrl + X, right-click the destination row number and choose Insert Cut Cells.

• To swap two individual cells: there is no direct swap command. Cut the first cell to an empty cell nearby, move the second cell into the first cell's position, then move the parked value into the second cell's position. Three moves, no data loss.

• To swap two adjacent cells quickly: select the first cell, hold Shift, and drag its border past the second cell. Excel slots it in on the other side.

If you need to turn columns into rows entirely rather than reorder them, that is a transpose rather than a swap: copy the range, right-click the destination, and choose the Transpose paste option.

Swapping versus replacing a column

These get searched interchangeably and they are not the same operation, so it is worth being explicit.

• Swapping exchanges the positions of two columns. Both sets of data survive, they just end up in different places. Everything above this section does that.

• Replacing means overwriting one column's contents with another's, or changing values inside one column. For the first, copy the source column and paste it over the target, accepting that the target's old values are gone. For the second, select the column and press Ctrl + H to open Find and Replace, which will only act on your selection.

If you replace by pasting, take a copy of the sheet first. Unlike a swap, a replace has nothing parked anywhere and Ctrl + Z is your only route back.

 

Frequently asked questions

Can I swap non-adjacent columns in Excel using drag and drop?

You can, but only if both columns fit on screen at once. For columns that are far apart, use Cut and Insert Cut Cells instead. It gives you exact control over the destination and does not require you to hold a drag across a scrolling sheet.

Will swapping columns affect my formulas in Excel?

If you move a column by Shift dragging or by Insert Cut Cells, Excel updates every reference to it automatically and nothing breaks. If you copy and paste over a column instead, the overwritten values are gone and formulas reading them silently return the new numbers.

Is there a way to swap columns without using the mouse?

Yes. Press Ctrl + Space to select the column, Ctrl + X to cut it, arrow across to the destination column, press Ctrl + Space again, then press Ctrl + Shift + Plus to run Insert Cut Cells.

Why does Excel say it cannot shift cells in a table?

You are trying to move whole worksheet columns while part of the range sits inside an Excel Table. Either click inside the table and drag the column by its table header, or go to Table Design and choose Convert to Range first.

How do I swap more than two columns at once?

Add a helper row above the headers, number each column with the position you want it to end up in, then use Data, Sort, Options, Sort left to right and sort by that row. All the columns move to their numbered positions in one action.

Does swapping columns break a VLOOKUP?

Very likely, and without any error message. VLOOKUP finds its result by counting columns from the left of its table array, so reordering changes which column that count lands on. Recheck the column index number in every VLOOKUP after a reorder, or switch to XLOOKUP, which references columns directly.

Final thoughts

Swapping columns is simpler than it looks once you know that Shift is what turns a drag into an insert, and that Insert Cut Cells inserts before the column you click. Use dragging for two visible columns, Cut and Insert for anything further apart, Sort left to right for a big reorder, and Power Query when the reorder has to happen again next month.

You can visit our homepage for more step-by-step guides, or browse the related articles below.

Related Articles

How to Calculate Percentage Change in Excel

How to Alternate Row Colors in Excel

How to use Excel for Budgeting

How to Unhide Columns in Excel