Excel Not Copying and Pasting Correctly? Fix It

If Excel is not copying and pasting correctly, first press Esc, select the source cells again, press Ctrl+C, click one destination cell, and press Ctrl+V. If the result is still wrong, use Home > Paste to choose the right paste type, then check for merged cells, filters, or formulas that change when moved.

Start with these quick checks

A straightforward copy should place the selected cells, including their contents and usually their formatting, at the destination. If nothing happens or the result looks unexpected, try this sequence before changing workbook settings:

Press Esc once or twice to cancel any active cell edit, dialog, or old copy selection. A moving dashed border around cells means Excel still has a copy operation active.
Select the source range again. Press Ctrl+C on Windows, or Command+C on Mac. For a range, make sure the selection includes every row and column you intend to copy.
Click the upper-left destination cell. For a multi-cell block, selecting only this one cell lets Excel fill the destination area from the copied block.
Press Ctrl+V on Windows or Command+V on Mac. Alternatively, use Home > Paste.
If the paste is wrong, undo it with Ctrl+Z on Windows or Command+Z on Mac, then choose a specific option from Home > Paste rather than repeating the same action.

These steps apply to Excel for Microsoft 365 on Windows. Excel for Mac uses Command instead of Ctrl for the usual copy, paste, and undo shortcuts. Excel for the web also supports common shortcuts, but the browser may show a clipboard permission prompt or restrict access; use the Home tab’s paste controls if a shortcut does not work.

What Excel copies—and what it may change

Copying cells can carry more than the visible words or numbers. A normal paste can include formulas, number formats, fonts, borders, fill colors, validation rules, and other cell properties. That is useful when duplicating a finished section, but it can make a paste look wrong if you wanted only the displayed values.

For example, copying a cell that displays “$1,250” may copy a formula and currency format, not a fixed value of 1250. The formula can recalculate at the destination, and the number format can make the destination appear different from nearby cells. Likewise, copying a cell with a date format can make a number display as a date. The underlying stored value and the way it is displayed are separate things.

Use the paste option that matches your goal:

Keep the full cell: Use the standard Paste command when you want contents, formulas, and formatting.
Keep only the result: Choose Home > Paste > Values. This pastes calculated results rather than the formulas that produced them.
Keep the look, not the content: Choose Home > Paste > Formatting.
Keep formulas but not the source appearance: Choose Home > Paste > Formulas.

The options visible in the Paste menu can vary with the copied content. If you do not see the exact choice, open the Paste dropdown on the Home tab and inspect its icons or labels before selecting.

When the pasted data has the wrong shape

A common problem is selecting a destination range that does not match the copied block. If you copy three columns by five rows, clicking one destination cell is usually simplest: Excel places the whole block starting there. If you instead preselect an incompatible area, Excel may refuse the paste or display an error. Undo, click a single starting cell, and paste again.

Check whether the source or destination contains merged cells. A merged area behaves differently from a regular grid, and copying between merged and unmerged ranges can produce an error or an unexpected layout. If the data does not need a merged appearance, unmerge the cells with Home > Merge & Center > Unmerge Cells, then try again. Before unmerging, check whether the merged cells contain important content: Excel retains the value in the upper-left cell and can discard content in other cells of the former merged area.

Hidden and filtered rows can also cause confusion. Copying a range does not always mean “copy only what I can see,” particularly when rows were hidden manually. To explicitly copy visible cells only, select the range, then choose Home > Find & Select > Go To Special > Visible cells only and confirm. Copy that selection and paste it into the destination. This is especially helpful when copying a filtered report without including hidden records.

If Excel says the copy and paste areas are not the same size, remove the destination’s multi-cell selection and click one starting cell. If the message persists, inspect merged cells and confirm that the copied selection is a single rectangular block rather than separate, nonadjacent selections.

Why formulas change after a paste

Excel normally adjusts relative references when a formula is copied to another location. This is expected behavior, but it can look like a copy error. For example, if a formula in C2 refers to A2, copying it one row down generally changes the reference to A3. Excel is adapting the formula to its new position, not changing the source cell.

Before pasting, decide whether the destination formula should move with the data or keep referring to the original cell. In a formula, dollar signs make a reference absolute: $A$2 stays fixed when copied, while A2 can adjust. You can also choose Home > Paste > Values when you need the current calculated results and do not want formulas to recalculate at the destination.

Another frequent source of surprises is calculation. A pasted formula may return a different result because its references now point to different cells, or because the destination workbook contains different data. Check the formula bar, not just the displayed result, to see whether the pasted cell contains a formula or a fixed value. If the result appears stale, check Formulas > Calculation Options and confirm whether the workbook is set to Automatic or Manual. Do not switch calculation modes casually in a shared workbook; manual calculation can leave other formulas temporarily out of date.

Fix formatting and values that look wrong

When the pasted text or numbers are correct but their appearance is not, the issue is usually formatting. A copied cell can bring along a font, fill, border, alignment, or number format that overrides the destination’s existing style. Undo the paste, then use Paste Values if you want the destination’s current formatting to remain. If the unwanted formatting is already there, select the affected cells and use Home > Clear > Clear Formats. This removes formatting without clearing the cell contents.

Numbers pasted from another program may be stored as text. Signs include values aligned differently from nearby numbers, a green triangle warning, or formulas that do not treat the entries as numbers. If Excel shows a warning icon, use its Convert to Number option when appropriate. Also check for leading apostrophes, spaces, or decimal and thousands separators that differ between the source and your regional settings. Do not convert blindly if the entries are identifiers such as product codes or postal codes; those may need to remain text so leading zeros are preserved.

When importing or pasting text with separators, Excel may split it into columns or keep it all in one column depending on the source and the import method. If the columns are wrong, undo the paste and use Data > Text to Columns for an existing column of delimited text. Review the delimiter and preview before completing the conversion, because choosing the wrong delimiter can split names, addresses, or other fields incorrectly.

When the clipboard or workbook blocks pasting

If Ctrl+C appears to do nothing, make sure Excel is not editing a cell. A cursor inside the formula bar or a text cursor in a cell means keystrokes may edit text instead of copying a range. Press Esc or Enter, click the cell itself, and copy again. Also check that the worksheet is not protected in a way that prevents changes to the destination, and that the destination cells are not part of a locked or restricted area.

Excel’s Office Clipboard can help when you need to inspect copied items. On Windows, open the Home tab and click the small dialog launcher in the Clipboard group to show the Clipboard pane. If the pane contains old items, use Clear All, then copy the cells again. If clipboard behavior remains stuck, save your work, close and reopen Excel, and retry. Restarting the application can clear a temporary clipboard problem, but save first so you do not lose unsaved changes.

When copying between workbooks, keep both workbooks open while you paste and verify that the destination workbook is active. A paste can also fail or behave differently when the source is in a protected view, an external application, or a browser. For Excel for the web, make sure the workbook is in editing mode and respond to any browser clipboard prompt. If a browser blocks a keyboard paste, try the ribbon’s Paste command or copy within the same workbook.

A reliable way to troubleshoot a recurring issue

Change one factor at a time so you can identify the cause instead of masking it. First undo the incorrect paste. Then copy a simple test cell in a blank worksheet and paste it nearby. If that works, the original workbook or selected range is likely involved. If it does not, test a new workbook and check whether another application or browser is affecting clipboard access.

For a difficult case, record what you copied, where you pasted it, and which paste option you used. Compare the formula bar and number format before and after. Then check these likely causes in order:

The destination was a multi-cell selection of the wrong size.
The range included merged, hidden, or filtered cells.
You needed Values or Formatting rather than a normal paste.
A formula’s relative references changed as intended.
The destination is protected, or the workbook is not in editing mode.
The source data contains text numbers, separators, or formatting from another application.

If only one workbook has the problem, make a copy of that file before experimenting with structural changes such as unmerging cells or changing protection. A small test in a duplicate can reveal whether the issue comes from workbook-specific layout or settings.

Frequently Asked Questions

Why does Excel paste formulas instead of numbers?
Normal Paste keeps formulas when the copied cells contain them. Choose Home > Paste > Values to paste the current results instead. If the result changes after a normal paste, inspect the formula’s cell references in the formula bar.

How do I copy only visible cells in a filtered list?
Select the relevant range, choose Home > Find & Select > Go To Special > Visible cells only, and confirm. Then copy and paste. This makes the visible-only selection explicit, which is useful when hidden rows must not be included.

Why does Excel say the copy area and paste area are different sizes?
You may have selected a destination block that does not match the copied range, or one range may contain merged cells. Undo, click only the destination’s upper-left cell, and paste. If it still fails, check for merged cells or a noncontiguous source selection.

How do I paste without changing the destination formatting?
Use Home > Paste > Values to bring over values without the source formatting. If you need formulas as well, choose Formulas. Available choices depend on what you copied and may appear as icons in the Paste dropdown.

Why does copy and paste work in one workbook but not another?
The problem may be specific to the affected workbook: protected cells, merged ranges, filters, or its layout can interfere with the operation. Test in a duplicate file and check the destination’s protection and cell structure before changing the original.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

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

Spotted an error in this guide? Let us know.