How to Copy Cells in Excel by Dragging

How-to basics · Updated November 20, 2026

To copy cells in Excel by dragging, select the source cell or range, point to the small square at the selection’s lower-right corner, and drag the fill handle over the destination cells. Excel fills the destination with the source data, formulas, and usually formatting; if it extends a number or date series instead, choose Copy Cells from the Auto Fill Options menu.

What You’ll Need

  • A workbook open in Microsoft Excel for Microsoft 365 on Windows, with the cells you want to copy visible.
  • A destination range that can be filled without overwriting information you need to keep. Dragging over occupied cells replaces their contents.
  • The fill handle enabled. It is normally on by default. If you do not see it, check File > Options > Advanced > Editing options > Enable fill handle and cell drag-and-drop.

You do not need to copy and paste first. For a nearby destination, the fill handle is usually the quickest option. If the destination is elsewhere on the worksheet, you can also drag the selection border while holding a modifier key, as described below.

Step-by-Step

  1. Select the source cell or range. Click one cell to copy it, or drag across a group of cells to select the whole range. For example, select A2:A4 if you want to repeat those three cells in rows below. If the range includes formulas, check that the references should adjust when Excel fills them into new locations.
  2. Find the fill handle. Look at the lower-right corner of the selected cell or range. A small square appears there when the selection is active. Move the pointer directly over that square, not over the middle or the outside border. The pointer changes to a thin black plus sign when it is over the handle. If the pointer looks like a four-headed arrow or a regular selection cursor, you are not on the fill handle.
  3. Drag across the cells to fill. Hold the mouse button down on the handle and move it down or to the right over the cells you want to fill. You can also drag upward or leftward. The shaded outline previews the destination range. Release the mouse button when the outline covers the cells you intend to fill. Excel fills the selected destination using the source cell or range.
  4. Check whether Excel copied or continued a pattern. Text such as a department name is typically repeated. A formula is copied and its relative references adjust to its new position. Numbers, dates, and recognized sequences may be extended instead. For instance, dragging a cell containing 5 may produce 6, 7, and 8 rather than four copies of 5. Do not assume the result is a copy just because the drag completed.
  5. Choose Copy Cells if Excel extended a series. After the drag, click the Auto Fill Options button that appears near the lower-right edge of the filled range, then select Copy Cells. The button appears only when Excel has relevant fill choices; it may disappear when you click elsewhere. If it is gone, undo with Ctrl+Z and repeat the drag, then open the menu before continuing your work.
  6. Review formulas and formatting. Click a couple of filled cells and check the formula bar or the displayed values. Relative references usually shift with the destination: a formula referring to B2 may refer to B3 when copied one row down. Absolute references marked with dollar signs, such as $B$2, stay fixed. Also check number formats, borders, and colors, since the fill operation may carry the source formatting into the destination.
  7. Repeat a multi-cell pattern when needed. Select the entire source block, then drag the fill handle at the block’s lower-right corner across the destination. For example, selecting A2:B3 and dragging down repeats the two-row, two-column pattern. Make sure the destination is large enough to accommodate complete repetitions; Excel fills the cells covered by the drag, so a partial final repeat may leave only part of the pattern.
  8. Copy to a distant location with border-dragging. If you want to place a copy somewhere that is not adjacent, select the source cells and point to the selection’s outside border. On Windows, hold Ctrl while dragging the border to the destination; release the mouse before releasing Ctrl. On Mac, use Option while dragging. This is different from dragging the fill handle: border-dragging moves the selection by default, while the modifier requests a copy. Check the destination after dropping, especially if it contains data.

Excel for the web also supports using the fill handle to fill nearby cells, although the available options and pointer behavior can vary by browser. On Mac, the fill-handle method is broadly similar, but modifier-key behavior and settings labels can differ from Windows. If you cannot use the handle, use the ribbon’s copy and paste commands instead.

Common Mistakes

  • Dragging the border instead of the handle. The fill handle is the tiny square at the selection’s bottom-right corner. Dragging the main border can move the selected cells and overwrite cells at the destination. To copy by border-dragging, use Ctrl on Windows or Option on Mac; otherwise, use the fill handle or copy and paste.
  • Assuming every value repeats exactly. Excel tries to recognize patterns. Numbers, dates, weekdays, and numbered labels may continue as a series. Look at the filled values and select Copy Cells in Auto Fill Options if you need identical entries.
  • Overlooking formula changes. When formulas are copied, relative references normally adjust for the new row or column. This is expected, but it can change the result if you wanted a reference to remain fixed. Use absolute references in the original formula when appropriate, or inspect the copied formula before relying on it.
  • Filling too far. It is easy to release the mouse one row or column beyond the intended range. The outline shows where the fill will go before release. If the result is wrong, press Ctrl+Z on Windows or Command+Z on Mac immediately, then repeat the drag carefully.
  • Expecting formatting to stay untouched. A normal fill can copy source formatting along with content. If that changes the destination’s appearance, use Auto Fill Options and choose Fill Without Formatting, if offered. If you want only the appearance, choose Fill Formatting Only when that option is available.

Tips

  • Use the fill handle for adjacent cells. It is particularly useful for copying a formula down a column or repeating a short block into nearby rows. For a large range, double-clicking the fill handle may fill down alongside an adjacent column of data, but check the endpoint: Excel uses the neighboring data to decide how far to fill.
  • Choose the destination direction deliberately. Drag down to fill rows below, right to fill columns to the right, or in the opposite direction to fill above or left. Keep an eye on the outline because it updates as you move the pointer.
  • Use Auto Fill Options as a correction, not a guess. After a fill, the menu lets you choose among behaviors such as Copy Cells, Fill Series, Fill Formatting Only, and Fill Without Formatting, depending on the selected content. The labels available can vary with the source data.
  • Check for hidden or filtered rows. Filling into a filtered list can produce a result that is not obvious from the visible rows alone. If the range is filtered, inspect the affected cells and consider clearing the filter or using a method designed for visible cells before filling.
  • Keep a clean source range. When repeating a block, avoid including a heading or a blank row unless you want that part of the pattern copied too. Select only the cells that make up the repeated data.
  • Undo promptly if the wrong cells change. Ctrl+Z on Windows and Command+Z on Mac undo the most recent fill or drag operation. Undo before making unrelated edits, which can make it harder to return to the previous worksheet state.

Troubleshooting

  • The fill handle is missing. On Windows, go to File > Options > Advanced, find Editing options, and turn on Enable fill handle and cell drag-and-drop. In Excel for Mac, open Excel > Preferences or Excel > Settings, then look under Edit for the fill-handle and cell-dragging setting; the wording and location vary by release. If the workbook is protected, some edits may also be restricted.
  • The cells become a sequence instead of duplicates. Click the Auto Fill Options button and select Copy Cells. If the button is no longer visible, undo and repeat the fill, then choose the option straight away. For a single numeric value, holding Ctrl while dragging the fill handle on Windows can switch between filling a series and copying, but the menu is the clearer way to confirm the result. Mac modifier behavior can differ, so use the menu when available.
  • The original cells move instead of being copied. You probably dragged the selection border. Undo, select the source again, and drag from the small fill-handle square. If you need to drag the border to a separate location, hold Ctrl on Windows or Option on Mac while moving it.
  • Nothing happens when you drag. Confirm that the pointer is on the fill handle and that fill-handle dragging is enabled. Try a small test with an empty destination. A protected worksheet, merged cells, or a workbook state that prevents editing can block or complicate the operation; check whether you can edit the source and destination normally.
  • The destination has unexpected formulas or values. Undo immediately, then check that you selected the right source and dragged over the intended range. If formulas were copied, inspect their references. If you only wanted static results rather than formulas, copy the cells and use Home > Paste > Paste Values instead of filling with the handle.
  • Formatting changed unexpectedly. Use Auto Fill Options to choose Fill Without Formatting, if offered. Alternatively, undo and repeat the fill, then use the option before continuing. If you need exact control over what is copied, standard copy and paste gives you more paste choices than dragging.

Frequently Asked Questions

Does dragging the fill handle copy formulas?
Yes. Excel fills the formula into the destination cells and adjusts relative references according to the new position. Absolute references remain fixed. Check the resulting formulas if the calculation depends on a particular cell staying constant.

How do I copy the same number instead of making a number series?
Drag the fill handle, click the Auto Fill Options button, and choose Copy Cells. On Windows, holding Ctrl while dragging the handle can also switch the fill behavior for numeric data, but verify the output before using it elsewhere.

Can I copy cells by dragging without copying their formatting?
Often, yes. After filling, open Auto Fill Options and choose Fill Without Formatting, if available. If that choice does not appear, undo the fill and use copy and paste with a values or other paste option that matches what you need.

Will dragging copy a cell to a non-adjacent area?
The fill handle is intended for filling adjoining cells. To drag a copy to a separate location in desktop Excel, drag the selection border while holding Ctrl on Windows or Option on Mac. You can also use copy and paste, which is often easier for distant destinations.

Why does Excel show a plus sign when I point at a cell?
The small black plus sign means the pointer is over the fill handle, so dragging should fill cells. If you see a four-headed arrow, you are over the selection border and may move the cells instead. Move the pointer to the tiny square at the lower-right corner.

Can I use this method in Excel for the web or on a Mac?
Yes, the fill handle is available in both, though menus, settings, and modifier-key behavior may differ from Windows desktop Excel. If a particular drag option is missing, use the Auto Fill Options menu or copy and paste.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.