How to Drag and Drop in Excel | Move, Copy, and Insert Data

Drag and drop in Excel lets you move or copy cells, rows, columns, and entire worksheet tabs with simple mouse gestures and modifier keys.

Knowing how to drag and drop in Excel is one of those skills that pays off in seconds every single day. The default move action works fine for quick rearrangements, but holding the right modifier key turns the same gesture into a copy, an insert, or a sheet duplicate. This guide covers all three actions, the exact key combinations for Windows and Mac, and the settings to check if the feature ever stops working.

Dragging and Dropping in Excel: Three Actions That Cover Every Task

Excel’s drag-and-drop system has three distinct behaviors, each controlled by a single modifier key. The default move action requires no key. Holding Ctrl (Windows) or Option (macOS) creates a copy. Adding Shift inserts the data instead of overwriting it. Once you know which key triggers which outcome, you can reorganize any sheet without touching the ribbon.

How to Move Cells with Drag and Drop

Moving data is the default behavior and requires no modifier key. Microsoft’s official instructions for moving cells describe the same sequence used in every modern version of Excel.

1. Select the cell, range, row, or column you want to move.
2. Hover the mouse pointer over the border of the selection until the cursor changes to a four-sided arrow.
3. Click and drag the selection to the new location.
4. Release the mouse button.

If the destination cells already contain data, Excel displays a warning asking you to confirm the overwrite. Click OK to proceed or Cancel to stop. The data now appears in the new location and is removed from its original position.

How to Copy Cells While Dragging

Copying via drag-and-drop places a duplicate at the destination while leaving the original intact.

1. Select the cells to copy.
2. Hold down the Ctrl key (Windows) or the Option key (macOS).
3. Point to the border until the cursor changes to an arrow with a small plus sign.
4. Drag to the destination, then release the mouse button.
5. Release the modifier key after the mouse button. Releasing it early reverts the action to a move and overwrites the destination.

How to Insert Cells While Dragging

Inserting instead of overwriting is the safest way to rearrange data that already has neighboring values. The Shift key tells Excel to push existing cells aside.

1. Select the cells you want to reposition.
2. Hold down the Shift key (on both Windows and macOS).
3. Drag the selection to the edge of the existing data until you see an insertion line — a thick vertical or horizontal bar.
4. Release the mouse button, then release Shift.

The existing cells shift to make room, and nothing gets overwritten. You can combine Ctrl+Shift (Windows) or Option+Shift (macOS) to copy and insert at the same time.

How to Drag and Drop Rows, Columns, and Worksheet Tabs

Rows and columns follow the same rules as individual cells. Click the row number or column letter to select the entire line, then drag its border with or without modifier keys. To move a row to a new position, select it, hover the border until the four-sided arrow appears, hold Shift, and drag to the insertion line between two existing rows.

Worksheet tabs work a little differently. Click a sheet tab at the bottom of the window and drag it left or right to reorder the sheets. Hold Ctrl (Windows) or Option (macOS) while dragging a tab to create an exact copy of that sheet, complete with all its data and formatting.

Can You Drag and Drop in Excel on Mobile?

No. Drag and drop for cells is not supported in Excel for iOS or Android. The touch interface does not provide the hover-based cursor changes or modifier-key combinations that the desktop feature requires. On a tablet or phone, use the Cut and Paste buttons in the ribbon instead.

Drag and Drop Stopped Working? Check These Settings

The feature is enabled by default, but it can be turned off — either accidentally or by a previous user. One checkbox controls both the fill handle (auto-fill) and cell drag-and-drop.

1. Go to File > Options > Advanced.
2. Scroll down to the Editing options section.
3. Make sure the Enable fill handle and cell drag-and-drop checkbox is ticked.
4. Below it, also check Alert before overwriting cells to avoid silent data loss.
5. Click OK to save the changes.

After re-enabling the option, restart Excel. The drag-and-drop pointer should return the next time you hover over a selection border.

Drag and Drop: The Complete Action Reference

The table above shows every modifier key at a glance. Memorizing the three main ones — Ctrl to copy, Shift to insert, Ctrl+Shift to copy and insert — covers nearly every situation you’ll encounter while reorganizing a sheet. Keep the “Alert before overwriting cells” setting turned on, and if the cursor ever stops changing to a four-sided arrow, the checkbox in Advanced options is the first place to look.