How to Drag and Copy in Excel | Move Data Without Typing

Copying cells in Excel using drag and drop saves time — hold Ctrl, drag the selection border, and release to duplicate data exactly where needed.

Knowing how to drag and copy in Excel saves you from repetitive keystrokes and keeps your workflow moving. Instead of reaching for Ctrl+C and Ctrl+V, you can select a range, hold the Ctrl key, and drag the selection border to a new spot — the original stays put, and a perfect copy lands where you dropped it. This works for cells, rows, columns, and even formulas, and it takes about two seconds once you recognize the cursor signal. Below you will find the exact steps, what to watch for, and the mistakes that trip up most users.

How to Drag and Copy in Excel: The Step Order That Works

The key to a clean drag-and-drop copy is getting the cursor shape right before you start moving the mouse.

1. Select the cell, row, or column you want to copy.
2. Move the mouse pointer to the border of the selection. The cursor changes from a thick white cross to an arrowhead.
3. Hold down the Ctrl key on your keyboard. A small plus sign (+) appears next to the arrowhead — that is the visual cue that copy mode is active, as documented in Microsoft’s official Excel support guide.
4. Click and drag the selection outline to the destination.
5. Release the mouse button first, then the Ctrl key.

The copy is complete. Excel does not warn you if the destination already contains data, so press Ctrl+Z immediately if you accidentally overwrite something.

What Happens When You Forget the Ctrl Key?

This is the single most common mistake in Excel drag operations — and it silently changes the action from copy to move. When you drag the border without holding Ctrl, the cursor shows a four-sided arrow with no plus sign. That moves the data instead of copying it, removing the content from the original location. Press Ctrl+Z to undo the move, then repeat with the Ctrl key held. The four-sided arrow means move; the arrow with a plus sign means copy — learn that visual difference and you will never lose data to this mistake again.

How to Copy Formulas by Dragging the Fill Handle

The fill handle is the small square in the bottom-right corner of a selected cell, and it is the fastest way to copy a formula into adjacent cells. Click the cell that contains the formula, then hover the cursor over the fill handle — the cursor changes to a thin black cross (+). Click and drag down, up, or across to fill the formula into the target cells. When you release, the formula copies with relative references adjusted automatically. For example, if cell A1 contains =B1+C1 and you drag the fill handle down to A2, the formula becomes =B2+C2.

To fill the formula down to the very last row of adjacent data, double-click the fill handle instead of dragging — Excel stops automatically at the last row with data in the neighboring column. This shortcut alone saves minutes on large sheets.

Does Drag and Copy Work in Excel for the Web?

Excel for the Web does not support the Ctrl+drag copy method — the cursor never changes to show the plus sign. Users working in a browser must use the standard Copy and Paste commands from the ribbon or the Ctrl+C and Ctrl+V keyboard shortcuts. The fill handle is also absent in the web version, so formulas must be copied and pasted manually. If you switch between the desktop app and the browser throughout your workday, keep this limitation in mind.

Drag and Copy Methods at a Glance

Common Mistakes That Waste Your Time

A few small errors cause most of the frustration with drag-and-drop copying, and each one has a one-second fix.

Dragging from the center of the cell. When you click the center, you select the cell content for editing rather than initiating a drag operation. Always click the border.

Releasing the Ctrl key before the mouse button. If you release Ctrl first, the selection snaps back or behaves unpredictably. Always release the mouse button first, then the Ctrl key.

Trying to copy into a filtered range. Drag-and-drop copying behaves unpredictably across hidden rows or columns. Unhide the range first, copy, then reapply the filter.

Drag Mistakes and Fixes

Which Copy Method Fits Your Task

For everyday copying of cells, rows, and columns, the Ctrl+drag method is the fastest — two seconds and you are done. For filling formulas down a column, the fill handle handles the work in a single drag. For users working in Excel for the Web or on a mobile device, stick with the keyboard shortcuts Ctrl+C and Ctrl+V. Each method has its place, and knowing all three means you never reach for a menu when a drag will do.