To move a column between existing columns, cut the whole column and use Insert Cut Cells at the destination header. Check the insertion position before continuing so that the existing data shifts into place.
Main walkthrough: Windows desktop Excel. On Mac, use Command+X for Cut. Menu availability and drag behavior can differ in Excel for the web and managed workbooks.
Start with a small practice table
Open the practice CSV in a new workbook. Its five fields are ID, Name, Region, Amount, and Status, in columns A through E. All records are fictional.
| ID | Name | Region | Amount | Status |
|---|---|---|---|---|
| 101 | Aki | East | 1200 | Open |
| 102 | Ren | West | 900 | Done |
| 103 | Mio | North | 1500 | Open |
Our first task is to move Amount before Name. Move the data underneath its heading too. Before trying this on a real workbook, save a copy so you can compare the result with the original.
| ID | Name | Region | Amount | Status |
|---|---|---|---|---|
| 101 | Aki | East | 1200 | Open |
| 102 | Ren | West | 900 | Done |
| 103 | Mio | North | 1500 | Open |
| ID | Amount | Name | Region | Status |
|---|---|---|---|---|
| 101 | 1200 | Aki | East | Open |
| 102 | 900 | Ren | West | Done |
| 103 | 1500 | Mio | North | Open |
Move a column with Cut and Insert Cut Cells
- Click the D column header to select the entire Amount column. Selecting D1 alone only selects the heading cell.
- Press Ctrl+X to cut the selection.
- Right-click the B column header and choose Insert Cut Cells.
- Check the new order: ID → Amount → Name → Region → Status. The amounts should still be 1200, 900, and 1500.
The destination header identifies the column you insert before. Here, Amount moves before B, and Name and Region shift right. Column letters describe the new positions afterward, so follow field names as well as letters.
Use Shift-drag on Windows desktop
Restore the original order before trying the mouse method.
- Select the entire Amount column using header D.
- Point at the border of the selected range. Avoid the divider used to resize column widths.
- Hold Shift and drag the selection to the boundary between A and B. Check the insertion line.
- Release the mouse button while still holding Shift, then release Shift.
If the pointer resizes the column or selects different cells, stop and use the Cut/Insert method. The visible insertion position is more useful than guessing a drag distance.
Move several adjacent columns
To move Name and Region together, select their adjacent B:C column headers and cut the block. Use Insert Cut Cells at the destination header. Their order inside the block stays the same.
Starting from the original table, inserting B:C before A produces Name → Region → ID → Amount → Status. For separated columns, move one at a time and recheck the current headers after each move.
Swap two distant columns while preserving the middle
To exchange Name and Amount while leaving Region between them, start from the original table and make two moves:
- Move Amount before Name. The order is now ID → Amount → Name → Region → Status.
- Find the current Name column, cut it, and insert it before Status.
- Confirm ID → Amount → Region → Name → Status.
After the first move, the original letters no longer identify the same fields. For the second move, select the heading Name rather than relying on its old B position.
Troubleshoot a move that does not work
| Symptom | What to check |
|---|---|
| Insert Cut Cells is unavailable | Exit cell edit mode and check worksheet protection. Ask the workbook owner when editing is restricted. |
| Merged-cell message | Inspect merged cells in both source and destination. Check their contents before changing the layout. |
| Only the column width changes | You are probably dragging the resize divider. Reselect the whole column and use Cut/Insert. |
| A table or filter is involved | Hidden rows and cells outside the visible area can matter. Try the move on a copy and handle complex layouts one column at a time. |
Afterward, check each ID against its amount, and inspect formulas and chart ranges. Text-based references and external integrations do not necessarily update just because columns moved.
Common questions
Is moving columns the same as transposing?
Reordering changes the left-to-right field order. To turn horizontal headings into vertical labels, use the rows-and-columns transposition guide.
How can I check the result?
The practice table should still have IDs 101, 102, and 103, with a total amount of 3600. Compare each ID’s Name and Amount with the original too; an unchanged grand total alone cannot prove that records stayed aligned.
Do I need VBA?
Built-in moves are suitable for an occasional layout change. Consider automation when you repeat the same transformation and can identify the target workbook and fields reliably.
Download the example
Example for this guideFree download · .csvUTF-8 CSV data. Import with Data → From Text/CSV. Set identifier columns to Text when leading zeros matter. Charts and formulas are added using the steps in this guide.
Further reading
Microsoft Support — Move or copy cells, rows, and columns ↗Menus and available features can differ by Excel version and platform. Check the example on a copy before applying it to important workbooks.