How to Move a Column in Excel

Rearranging columns is one of the most common Excel tasks, whether you’re putting a report in a logical order or matching a template someone sent you. The trick most people miss is the Shift key. Drag a column without it and Excel overwrites the data where you drop it. Hold Shift and Excel slides the column into place and shifts everything else over.

This guide covers the Shift-drag method, cut and insert, moving several columns at once, reordering a whole sheet in one go, and how to fix the most common errors.

How to Move a Column in Excel with Shift-Drag

Step 1: Select the column

Click the column letter at the top of the sheet, such as C, to select the entire column. To move just part of a column, select those cells instead.

Step 2: Find the move pointer

Hover over the left or right edge of the selection until the pointer changes to a four-headed arrow. Don’t use the small square in the bottom-right corner, which is the fill handle.

Step 3: Hold Shift and drag

Press and hold Shift, then click and drag the column. A thick green or gray line shows where the column will be inserted between two existing columns.

Step 4: Release the mouse, then Shift

Let go of the mouse button first, then the Shift key. The column moves into its new position and the other columns shift to make room. Nothing is overwritten.

If you drag without Shift, Excel asks whether you want to replace the contents of the destination cells. Click Cancel unless that’s what you intended.

Move a Column with Cut and Insert

This method is more precise on large sheets and doesn’t require steady mouse work.

1. Click the column letter and press Ctrl + X.
2. Click the letter of the column that should end up to the right of the moved column.
3. Right-click and choose Insert Cut Cells, or press Ctrl + Shift + =.

Excel inserts the column and shifts the rest to the right. Microsoft covers both mouse and menu methods in its guide to moving or copying cells, rows and columns.

Move Several Columns at Once

Select adjacent columns by clicking the first column letter and Shift-clicking the last, then Shift-drag or cut and insert them as a block. Excel can’t move non-adjacent columns together. If you select columns C and F with Ctrl and try to cut them, you’ll get an error, so move them one at a time.

Move a Column Inside an Excel Table

In a formatted table, select the column by hovering over the top edge of the header cell until a small down arrow appears, then click. Shift-drag the selection to its new place. Table formulas and structured references update automatically. To move the whole table instead, see how to move a table in Excel.

Reorder Many Columns at Once

If you need to rearrange a whole sheet, moving columns one by one is slow. Two faster options:

• Sort left to right: insert a blank row above your headers and number each column in the order you want. Select the data including that row, go to Data > Sort > Options, choose Sort left to right, sort by the helper row, then delete it.
• CHOOSECOLS in Microsoft 365: on a new sheet, =CHOOSECOLS(Sheet1!A1:F100,3,1,2,6,4,5) returns the columns in the order listed. Copy and paste as values if you need a static copy.

Move a Column with the Keyboard Only

1. Click any cell in the column and press Ctrl + Space to select the column.
2. Press Ctrl + X to cut it.
3. Use the arrow keys to move to the destination column, then press Ctrl + Space again.
4. Press Ctrl + Shift + = to insert the cut column.

What Happens to Formulas

• Formulas that refer to the moved cells update automatically and still point to the same data.
• Formulas inside the moved column keep working.
• Hard-coded column numbers, such as the column index in VLOOKUP, don’t update. Check those after moving, or switch to XLOOKUP or INDEX/MATCH, which reference columns directly.

Troubleshooting

• “There’s already data here. Do you want to replace it?” You dragged without holding Shift. Click Cancel and try again with Shift held down.
• “This action won’t work on multiple selections.” You selected non-adjacent columns. Move them one at a time.
• “We can’t do that to a merged cell.” Merged cells cross the column boundary. Unmerge them with Home > Merge & Center, move the column, then re-merge if needed.
• Hidden columns moved too. Hidden columns inside your selection travel with it. Unhide them first if you want to leave them behind.
• The move pointer never appears. Turn on File > Options > Advanced > Enable fill handle and cell drag-and-drop.
• The sheet is protected. Unprotect it from the Review tab.

Tips

• Press Ctrl + Z immediately if a column lands in the wrong place.
• Freeze the header row before moving columns on long sheets so you can see what you’re rearranging.
• After moving, AutoFit the column widths so the headers fit.

Frequently Asked Questions

Can I move multiple columns at once?

Yes, as long as they’re next to each other. Select them as a block and Shift-drag or cut and insert.

Will moving a column break my formulas?

No. Cell references update automatically. Only hard-coded column numbers in functions like VLOOKUP need checking.

Can I move columns in Excel for the web?

Yes. Shift-drag works in the browser, and so does cut with right-click Insert Cut Cells.

How do I move a row instead?

The same way. Select the row number, then Shift-drag it or cut and choose Insert Cut Cells on the destination row.

Does it work on a Mac?

Yes. Hold Shift while dragging, or use Command + X and Insert Cut Cells.

Wrapping Up

Select the column, hold Shift, and drag it to its new spot, or cut it and use Insert Cut Cells. For big rearrangements, sort left to right or use CHOOSECOLS. Formulas follow the data automatically, so the only things to double-check are VLOOKUP column numbers.