To move a column in Excel, select the whole column, then either hold Shift and drag its border to drop it between two other columns, or Cut it and choose Insert Cut Cells at the spot you want. Both routes open a gap for the column instead of landing it on top of another one. A plain drag with no Shift does the reverse: it drops the column onto the destination and replaces what was there, which is why the two dependable moves are the Shift-drag and Cut plus Insert Cut Cells.
Moving a column changes where it sits in the left-to-right order while the rows stay put. That is a different job from taking a column off the screen, which is hiding a column, and from reordering the rows by a column’s values, which is sorting. What follows is how to make the move without clobbering the columns already there, and what it can do to formulas that were reading the old layout.
How do I move a column by dragging?
Click the column header, the gray letter at the top of the grid, so the whole column is selected. Point at the edge of that selection until the cursor turns into a four-way move arrow. Now hold Shift and drag sideways: as you pass over the boundary between two columns, Excel opens a gap there, and releasing the mouse drops the column into it. The columns to the right slide over to make room, and nothing already in the sheet is written over.
Let go of the drag without Shift and you get the other outcome. A plain drag is a cut-and-replace: it carries the column to wherever you release it and drops it on top of the column already there. Excel stops you with a warning before it overwrites a column, so you can cancel and try again with Shift held. Microsoft’s own note is to keep Shift down until after you release the mouse button, so the move stays an insert rather than turning back into a replace.
How do I move a column with Cut and Insert Cut Cells?
When a precise drag is fiddly, the menu route is steadier, and it handles a column of any width. Click the column header to select the whole column, then on the Home tab, in the Clipboard group, select Cut, or press Ctrl+X. A moving border appears around the column to show it is ready to go.
Now right-click the header of the column that currently sits where you want the moved column to land, and choose Insert Cut Cells. Excel drops the cut column into that spot and shifts that column, and every column to its right, one place further right to make room. Because it inserts rather than pastes over, nothing in the destination is overwritten. In Microsoft’s words, “When you move or copy rows and columns, by default Excel moves or copies all data that they contain, including formulas and their resulting values, comments, cell formats, and hidden cells.”
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Name | Q1 | Q2 | Total |
| 2 | East | 100 | 120 | 220 |
| 3 | West | 90 | 110 | 200 |
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Name | Total | Q1 | Q2 |
| 2 | East | 220 | 100 | 120 |
| 3 | West | 200 | 90 | 110 |
How do I move several columns at once?
To move a block of neighboring columns together, drag across their headers first so the whole block is selected, then take either route: hold Shift and drag the block, or Cut it and Insert Cut Cells at the destination. The one catch is that the columns have to be next to each other. Excel cannot move nonadjacent columns with the mouse, so if the ones you want to reorder are scattered, move them one at a time, cutting and inserting each in turn.
What breaks the references when you move a column?
Moving a column with Cut and Insert Cut Cells relocates its cells; it does not delete them or write over anything, so a clean insert is not what strands a formula. Microsoft names what does: “This happens most often when cells that were referenced by formulas get deleted, or pasted over.” That maps onto two ways a column move can go wrong. Delete a column that a SUM or a lookup was reading and those formulas drop to #REF!. Let a plain drag replace a column, and the same thing happens to anything that pointed at the cells you covered.
A second case is easy to overlook. Excel carries a moved formula without changing the references inside it, so a formula you shift can still be pointing at its old neighbors by their addresses rather than at the data that traveled with it. After you rearrange columns, it pays to look over the formulas that read them. What a reference is, and why moving cells can change what it resolves to, is covered in cell references; what a #REF! means and how to correct it is in Excel errors explained.
The short version
- Drag: select the column, then hold Shift and drag its border to drop it between two others; Excel opens a gap and the columns to the right slide over. Without Shift, a plain drag replaces the destination.
- Cut and insert: select the column, Cut it (Ctrl+X), right-click the destination column header, and choose Insert Cut Cells; that column and everything to its right shift one place right, and the cut column drops into the gap.
- Several at once: select adjacent columns together, then drag or Cut and Insert them; the mouse cannot move nonadjacent columns.
- What breaks references: a Cut and Insert Cut Cells move relocates cells rather than deleting them, so it does not by itself cause
#REF!; deleting a referenced column, or letting a plain drag overwrite one, is what leaves#REF!behind. See cell references and Excel errors explained. - Not the same as: hiding a column takes it off the screen; sorting reorders rows by a column’s values; Text to Columns splits one column into several; and transposing turns a row into a column instead of sliding a column sideways.
