Dropping a dragged Excel column over another column triggers a replace warning, and choosing the wrong option overwrites the destination. The clean move starts from the column heading, then uses the right key to move, insert, copy, resize, or restore dragging when Excel stops accepting drag-and-drop.
Move a column by dragging it
Select the column heading for the column you want to move.
Point to the border of the selected column.
On Windows, wait for the move pointer. On Excel for the web and on Mac, wait for the hand pointer.
Drag the selected column to its new location.
If Excel warns that you are about to replace a column, continue only when replacing that destination column is the goal.
Select Cancel when you meant to insert the column between existing columns.
On Windows, use this drag move only when replacing the destination column is the intended result.
Excel for the web reverses those roles: a plain drag cuts the column and inserts it, so Excel makes room at the destination, and holding Shift while you drag is what replaces the destination column.
Insert a dragged column without overwriting data
This fixes a dragged column landing on top of existing data instead of making room.
Select the column heading.
Hold Shift.
Point to the border of the selection.
Wait until the pointer changes to the move pointer.
Drag the column between two existing columns.
Release the mouse at the insertion position so Excel makes space for the moved column.
Copy a column by dragging
Use this when you need a duplicate column and want the original to stay where it is. The modifier key changes by platform, so match the shortcut to your version of Excel.
On Windows or Excel for the web, select the column heading.
Hold Ctrl.
Point to the border of the selection.
Drag the column to another location.
To copy and insert the column on Windows, hold Shift and Ctrl while you drag to the insertion point.
In Excel for the web, Ctrl on its own copies and inserts the column, and Shift with Ctrl copies and replaces the destination column.
On Mac, select the column heading.
Point to the border until the hand pointer appears.
Hold Option and drag the column to another location.
To put a dragged Mac column between existing columns, hold Shift while dragging so Excel makes space for it.
Use the cut and insert method instead
Dragging is fast, but Insert Cut Cells gives you a precise landing point and keeps nearby columns from being replaced.
Select the column heading.
Open Home, go to the Clipboard group, and select Cut. You can also press Ctrl+X.
Right-click the column to the right of where you want the moved column to land.
Select Insert Cut Cells.
For a copy instead of a move, select Copy or press Ctrl+C, then right-click the destination column and choose Insert Copied Cells.
If this method fails, use the Shift-drag insert method above and drop the column between existing columns.
Resize columns by dragging their edge
To change one column width, move the pointer to the boundary on the right side of the column heading, then drag until the column reaches the width you want.
To resize several columns together, select the columns first, then drag the boundary to the right of any selected column heading.
To resize every column in the worksheet, choose Select All, then drag the boundary of any column heading.
For an exact width, select the column or columns, open Home, choose Cells, select Format, choose Column Width, type the value in Column width, and select OK. You can also right-click the selected column, choose Column Width, type the value, and select OK.
AutoFit a column after dragging
AutoFit is useful after you move or resize a column and the contents still look cramped or too wide.
Select the column heading for the column or columns you want Excel to adjust.
Double-click the boundary to the right of a selected column heading.
Excel changes the selected column width to fit the contents.
If AutoFit fails, set the width manually from Home, Cells, Format, and Column Width.
Turn drag and drop back on
The most common setting behind this is Excel's cell drag-and-drop option being turned off.
On Windows, open File, then Options, then Advanced.
Under Editing options, select Enable fill handle and cell drag-and-drop.
To control overwrite warnings, select or clear Alert before overwriting cells.
On Mac, open Excel, then Preferences, then Edit.
Under Edit Options, turn on Allow fill handle and cell drag-and-drop.
Drag columns on iPhone, iPad, and Android
The mobile apps use touch gestures instead of a desktop pointer.
- 1.Tap the column heading to select the column.
- 2.Tap and hold the selected column.
- 3.On iPhone or iPad, wait for the dotted lines to animate.
- 4.Drag the selected data to the location you want.
- 5.To resize on iPhone or iPad, tap and drag the column heading, or double-tap it for AutoFit.
- 6.To resize on Android, drag the double-line indicator at the edge of the column heading.
Handle a managed work device that blocks dragging
On managed work or school devices, an organization can enforce Office settings that disable the fill handle and cell drag-and-drop. On a personal device, control the same behavior from Excel's Options or Preferences screen.
If the setting keeps turning off on a managed device, use Insert Cut Cells or ask your workplace support team whether the Excel drag-and-drop setting is restricted.
Frequently Asked Questions
Does dragging columns work in Excel for the web?
Yes. Select the column heading and drag from the border. On the web, hold Ctrl while dragging to copy and insert the column. Shift with Ctrl copies and replaces the destination column instead.
How do I drag formulas across columns in Excel?
Select the cell that has the formula, then drag the fill handle across the cells you want to fill. If Auto Fill Options appears, open it and choose the fill option you want.
What shortcut fills a formula across columns without dragging?
Select the formula cell and the adjacent cells you want to fill, then use Home > Fill > Right or press Ctrl+R. For filling down a column, press Ctrl+D.
Can I move an Excel page break by dragging near columns?
Yes. Open View > Page Break Preview, then drag the page break to a new location. If the page break will not drag, turn on Enable fill handle and cell drag-and-drop from File > Options > Advanced.