Excel Not Letting You Copy and Paste? Fixes That Work

If Excel will not copy and paste, first press Esc, select one ordinary cell, copy it with Ctrl+C, then select a blank cell and press Ctrl+V. If that works, the problem is likely the original selection, the destination, or the workbook’s state; if it does not, check whether Excel or another app is interfering with the clipboard.

Start by identifying what is failing

Copying can fail at different points: Excel may not place the selection on the clipboard, it may copy only text rather than cells, or the destination may reject the paste. A quick test helps separate these cases. In a blank worksheet, type a short word into A1, select A1, press Ctrl+C, and then select B1 and press Ctrl+V. If the word appears in B1, basic copying within that workbook works. Try copying the same cell into another workbook, then into Notepad. These tests help show whether the issue is limited to a particular range, workbook, or application.

After selecting a cell and copying it, Excel normally displays a moving dashed outline around the copied cell or range. That outline indicates that Excel is still in copy mode. If it is absent, the copy command may not have registered, or another action may have canceled it. Pressing Esc deliberately exits copy mode, so do not press it between copying and pasting unless you intend to cancel the operation.

Check the selection and copy mode

Excel expects a paste destination that fits the copied content. When you copy a rectangular range, select the upper-left cell of the destination rather than selecting a differently sized block first. For example, copy A1:B3 and click D1 before pasting; Excel will fill D1:E3. Selecting only a single top-left destination cell is usually the simplest approach. A mismatch between source and destination sizes can produce a paste error.

Cancel an accidental selection state: Press Esc once, click a single cell, and retry. If Excel is editing a cell, press Enter or Esc to finish or cancel the edit before copying cells.
Copy one continuous range: A selection made with Ctrl-click can contain separate areas. Excel cannot always paste multiple nonadjacent areas as one normal rectangular block. Copy each area separately or make a continuous selection.
Use the ribbon to test the shortcut: Select the source, choose Home > Clipboard > Copy, click the destination, and choose Home > Clipboard > Paste. If the ribbon works but Ctrl+C does not, a shortcut, keyboard, or other application may be intercepting the keystroke.
Check for cell-edit mode: If the insertion point is inside a cell or the formula bar, Ctrl+C may copy selected text rather than the whole cell. Press Enter, click the cell once, and copy again.

On Windows, Ctrl+C and Ctrl+V are the standard shortcuts. On a Mac, use Command+C and Command+V. Escape cancels copy mode on both platforms.

Make sure the destination allows a paste

A worksheet can allow you to select or copy a cell while preventing you from changing the destination. This commonly happens when sheet protection is on. Check Review > Unprotect Sheet; Excel may ask for a password, which you need from the workbook owner if one was set. On a protected sheet, whether users can select locked or unlocked cells depends on the protection settings. Even if a cell can be selected, it may not be editable.

Other destination conditions can also block pasting. A merged-cell layout that differs between source and destination can cause an error, as can trying to paste into a range that overlaps an incompatible table or array result. Try a blank, unmerged area on an unprotected sheet. If that works, the clipboard itself is probably fine; the original destination’s layout or restrictions are the issue. Also check that you are not trying to paste into a chart, shape, or other object while expecting a cell-range paste.

When pasting into a filtered list, Excel may paste into the selected range in a way that does not match the visible rows you have in mind. Hidden or filtered rows can make the result seem misplaced. For a controlled test, paste into an unfiltered blank range. If you need to copy only visible cells, select the range and use Home > Find & Select > Go To Special > Visible cells only before copying. Inspect the selection before pasting, because the resulting shape may not be a single uninterrupted block.

Distinguish cell copying from copying text

Copying a cell from Excel to another program does not always behave like copying it to another worksheet. Between cells, Excel can transfer values, formulas, formatting, and other cell information. Into a text editor, it generally transfers text representations of the selected cells; a block may be separated by tabs and line breaks. A formula cell may therefore appear as its displayed result in a plain-text destination rather than as an editable Excel formula.

For a cell-to-cell paste, Excel’s Paste options can help when the full paste is not wanted. After copying, use the Paste menu on the Home tab to choose a supported option such as Values or Formulas. Values are useful when you want a fixed result instead of a formula that refers to other cells; formulas are useful when you want to retain calculations without the source formatting. If normal paste fails in a particular destination, these options are not a universal workaround, but they can help isolate whether the problem is with formatting or with the cell content itself.

Test whether another app or the clipboard is involved

The Windows clipboard is shared by Excel and other applications. A clipboard manager, remote-desktop session, synchronization tool, or another program can sometimes disrupt copy and paste. Test with a simple sequence: copy text from Notepad into Notepad, copy from Excel into Notepad, and copy from Notepad into Excel. If only one direction fails, that narrows down where to look. Close other apps that monitor or manage clipboard contents, then repeat the test.

Windows clipboard history can be viewed with Win+V if clipboard history is enabled. It is a diagnostic aid, not a requirement for ordinary Ctrl+C and Ctrl+V. If the history panel is empty, that alone does not prove copying is broken: history may be off, restricted, or cleared. Restarting Excel and the computer can clear a temporary application or clipboard problem. If you use remote access, test locally or check the remote session’s clipboard-sharing setting; the setting is managed by the remote-access software, not by Excel.

Look for workbook or Excel-specific causes

If copying works in a new workbook but fails in one particular file, focus on that workbook. Check for sheet protection, merged cells, unusual selection shapes, or a destination inside a structured table. Save a separate copy and test there rather than making risky changes to the only original. If the workbook is stored in a shared location, wait for syncing or coauthoring activity to settle and try again; a syncing delay can affect what you see, though it is not the same as a clipboard command being disabled.

If the problem happens in every workbook, an Excel add-in or temporary Office issue is more plausible. Close and reopen Excel first. To test add-ins on Windows, start Excel in Safe Mode by pressing Win+R, entering excel /safe, and pressing Enter. If copying works in Safe Mode, an add-in or customization may be involved. In normal Excel, open File > Options > Add-ins. At the bottom, select COM Add-ins beside Manage and choose Go; disable add-ins temporarily, then re-enable them one at a time to identify a cause. Menu labels can vary slightly by Office build.

If Safe Mode does not help, install available Microsoft 365 updates and consider repairing Office through Windows Settings > Apps > Installed apps > Microsoft 365 > Modify. Available repair choices depend on the installed version and organization settings. Ask your IT administrator before changing managed settings on a work computer.

Excel for the web and Mac differences

In Excel for the web, the browser can affect clipboard access. If a keyboard shortcut does nothing, use the ribbon’s Copy and Paste commands, respond to any browser permission prompt, and check whether the browser or organization restricts clipboard access. Try another supported browser or a desktop version of Excel if the issue continues. Web Excel also runs inside a browser tab, so shortcuts can be intercepted by the browser or an extension.

On Mac, use Command+C and Command+V rather than the Windows Ctrl shortcuts. If the ribbon command works but the keyboard shortcut does not, check keyboard settings and any utilities that remap shortcuts. The core diagnosis is otherwise the same: test one cell in a blank workbook, check whether copy mode remains active, and try a different destination. Avoid assuming that Windows instructions for clipboard history or Excel Safe Mode apply on a Mac.

Frequently Asked Questions

Why does Excel say I cannot paste because the copy area and paste area are not the same size?
Excel is warning that the selected destination does not match the copied range. Copy the source range, click only the upper-left destination cell, and paste. If the source contains merged cells or multiple separate areas, simplify the selection and try again.

Why does Ctrl+C copy text from a cell instead of the whole cell?
You are probably editing the cell or formula bar, or you selected text inside it. Press Enter or Esc to leave edit mode, click the cell once, and copy. On Mac, use Command+C.

Can I copy cells from a protected worksheet?
Protection settings determine what can be selected, and a protected destination may not allow edits. You may be able to copy a permitted cell but still be unable to paste into a locked cell. Ask the workbook owner to change protection settings if you do not have authorization to unprotect it.

Why does copy and paste work in one workbook but not another?
The affected workbook may have protection, merged cells, a complex selection, or a destination that cannot accept the pasted range. Test in a blank area or a separate copy of the file. If copying works elsewhere, the issue is likely specific to that workbook or destination rather than the general clipboard.

Why does Excel paste a value instead of my formula?
Some destinations, especially plain-text apps, receive the cell’s displayed text rather than an Excel formula. When pasting into Excel, use the regular Paste command or choose Formulas from the Paste menu if you need the calculation. Confirm that the copied source cell actually contains a formula.

What should I try if copy and paste fail everywhere in Excel?
Restart Excel, test the ribbon commands, and compare behavior in a blank workbook. On Windows, try Excel Safe Mode to check for add-ins. If the issue remains across workbooks and applications, restart the computer and check for Office updates or clipboard-management software.

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.