Excel Not Allowing Copy and Paste? How to Fix It

If Excel is not allowing copy and paste, press Esc, select a normal cell, and try Ctrl+C followed by Ctrl+V; if it still fails, check edit mode, sheet protection, merged cells, and clipboard access. The cause may be a selection or workbook restriction rather than a broken keyboard shortcut, so work through the checks below in order.

Start with a quick copy-and-paste check

Try copying one ordinary cell into a blank cell on the same worksheet. This simple test helps separate a general clipboard problem from an issue affecting a particular range, sheet, or destination. On Windows, select the cell and press Ctrl+C, then select the blank destination and press Ctrl+V. On a Mac, use Command+C and Command+V. You can also use Home > Copy and Home > Paste.

Watch for the moving dashed border around the copied cell. If it is not visible, Excel may not have copied the selection, or another action may have canceled copy mode. Pressing Esc cancels the moving border; it does not copy anything. If the test works, repeat the operation with the original cells and destination. If it fails, continue with the checks below.

Try copying a single cell rather than a whole row, column, or multi-area selection.
Try a different blank destination on the same worksheet.
Test copying between two worksheets in the same workbook, then between two workbooks.
Check whether copying works in another application. If it does not, the problem may involve the operating system clipboard rather than Excel alone.

Check whether Excel is still editing a cell

Excel treats copying differently when you are editing the contents of a cell. This can happen after you double-click a cell, start typing, or click inside the formula bar. In that state, Ctrl+C may copy selected text from the cell entry instead of copying the cell itself, and a paste may insert text into the formula or value rather than into another cell.

Press Enter to commit the edit or Esc to cancel it, then select the cell by clicking once on its border or by using the arrow keys. The formula bar should no longer have an active text cursor. Then try the copy again. If the status bar or formula bar suggests that you are entering or editing a value, finish or cancel that action before copying a range.

Also check whether a dialog box is open, such as Find and Replace or a paste-related prompt. Excel may not accept worksheet shortcuts normally while a dialog is active. Close or complete the dialog first. If the selected cell is inside a chart, text box, or other object, click a worksheet cell to return focus to the grid.

Look for sheet protection and read-only restrictions

A protected worksheet can prevent changes to locked cells, including pasting into them. You may still be able to select or copy cells, so a failure that happens only at the destination often points to protection or permissions. On Windows, check the Review tab for Unprotect Sheet. If that command is available and you are authorized to edit the sheet, select it; Excel may ask for a password. Do not try to bypass a password—ask the workbook owner for access.

Workbook structure protection is a separate restriction. It can limit actions such as adding, deleting, moving, or renaming sheets, but it is not the same as protecting the cells on a worksheet. Likewise, a file opened as read-only or with editing disabled may allow viewing and some copying while blocking changes. Check the workbook title bar and any message near the top of the window. If Excel shows an Enable Editing button for a file you trust, enabling editing may be necessary to paste changes.

When a workbook is shared or stored online, your account may have view-only access, or another access policy may prevent editing. Confirm that you have edit permission and that the workbook is not open in a restricted mode. If only one sheet or a specific range rejects pasting, ask the file owner whether those cells are intentionally locked.

Check the selected range and destination layout

Some copy operations fail because of the shape of the selection rather than the clipboard. Excel generally expects a copied rectangular range to fit the destination. For example, copying a block that is three columns wide into a selection that is two columns wide can produce an error. Select just the upper-left destination cell and let Excel fill the matching-size area, or make the source and destination ranges the same size.

Nonadjacent selections—such as holding Ctrl while selecting separate blocks—can also cause problems. Excel does not support every copy-and-paste operation on multiple separate areas. Copy each block individually, or temporarily put the data into one contiguous range before copying it.

Merged cells are another frequent source of errors. A copied range and its destination may have different merged-cell layouts, so Excel cannot map the cells consistently. Try pasting into an unmerged blank area. If appropriate, select the merged cells and choose Home > Merge & Center > Unmerge Cells, then retry. Unmerging changes the worksheet layout, so confirm that it will not disrupt a report or template before doing so.

Filtered lists and hidden rows can make pasted results look incomplete or misaligned. Before pasting a multirow block, verify which rows are visible and whether the destination includes hidden or filtered-out rows. For a critical data update, paste into a clean worksheet or a clearly defined matching range, then compare the result before replacing the original.

Separate clipboard problems from paste-format problems

If the paste command is available but the result is wrong, Excel may be pasting content successfully in a form you did not expect. A normal paste can include values, formulas, formatting, comments, and other cell attributes. It can also replace existing destination content. Use Home > Paste to choose a suitable paste option, or right-click the destination and inspect the available options.

Paste Special can help when you need only part of a cell. For example, choose Values when you want the displayed results without the source formulas, or choose Formulas when you want formulas but not the original formatting. The available choices depend on what was copied. If Paste Special is unavailable or offers fewer options than expected, try copying the cells again and make sure the dashed copy border is still visible.

Copying from another program adds another variable: the source may place formatted text, an image, or tab-delimited text on the clipboard rather than a native Excel cell range. If the paste looks unusual, use Paste Special to choose a compatible representation, or paste into a plain-text editor first to see whether the source is providing text. Be careful with text that contains commas, tabs, or line breaks, since those characters can affect how Excel distributes data across cells.

Refresh the clipboard and check other applications

Close any open cell edit with Enter or Esc, copy a single cell again, and paste immediately. If Excel still does not respond, try copying and pasting in another application. A clipboard manager, remote desktop session, virtual machine, or security utility can interfere with transfers between programs. If copying works within Excel but not between Excel and another app, the boundary between applications is a useful clue.

On Windows, the Windows clipboard history can be opened with Windows key+V if clipboard history is enabled. It is not required for ordinary Ctrl+C and Ctrl+V, and turning it on is not a universal fix. Excel also has an Office Clipboard that can collect copied Office items; in Excel, open the Home tab and use the small dialog launcher in the Clipboard group to view it. If the Office Clipboard appears to be causing confusion, clear its list and make a fresh copy.

In a remote desktop or virtual machine, clipboard sharing may be disabled by the connection settings or an administrator. Check whether copying works inside the remote session and whether it works between the remote computer and your local computer. If only cross-device copying fails, the session’s clipboard-redirection policy is more likely than a worksheet setting. On managed work devices, contact IT rather than changing security controls.

Excel for the web and Mac have different clipboard details

Excel for the web runs inside a browser, so browser clipboard permissions and security rules can affect copying between Excel and other websites or desktop applications. If the browser displays a clipboard permission prompt, allow access only when you trust the page and need the feature. Try the keyboard shortcut as well as the ribbon command, and check whether the issue occurs in another supported browser or only when transferring content to or from the desktop.

In Excel for the web, copying within the workbook may work even when pasting from an outside application is blocked or prompts for permission. A practical workaround is to copy the source data into a plain-text editor, then copy it again into Excel, if preserving rich formatting is not necessary. For files that need advanced desktop features or repeated large transfers, open the workbook in the Excel desktop app if you have access to it.

On Mac, use Command+C and Command+V rather than the Windows Ctrl shortcuts. The menu and ribbon names are broadly similar, but some settings and keyboard behavior differ by platform. If a Windows instruction does not match the Mac interface, use Excel’s menu or Help search to locate the equivalent command. Avoid assuming that a Windows clipboard-history shortcut or setting exists on macOS.

Restart Excel and narrow down add-in issues

If simple copying fails across multiple workbooks, save your work and close Excel, then reopen it. This can clear a temporary application or clipboard state. If the problem persists, restart the computer and install available Office updates through the update controls provided for your Microsoft 365 installation. Save important changes before restarting, especially if AutoSave or cloud synchronization is not active.

An Excel add-in or other software can sometimes affect application behavior. To investigate, start Excel in Safe Mode on Windows by holding Ctrl while launching Excel and confirming the prompt, then test a new blank workbook. Safe Mode limits some startup features and add-ins. If copying works there but not during a normal start, review active add-ins through File > Options > Add-ins. Change add-ins one at a time and follow your organization’s rules; do not disable security or business-critical tools without approval.

For a problem limited to one workbook, make a copy of the file and test the copy. A damaged or unusually complex workbook may behave differently from a new blank workbook. If the issue appears only in a particular file, ask the owner for an unprotected or freshly saved copy rather than rebuilding it immediately. Keep the original unchanged until you have confirmed that the replacement contains the expected data and formatting.

Frequently Asked Questions

Why does Excel say I can’t paste the data?
Common causes include a source and destination range with different shapes, a multi-area selection, merged cells, or a protected destination. Try copying a rectangular range and pasting into one upper-left destination cell, then check the worksheet’s protection and merged-cell layout.

Why can I copy but not paste in Excel?
The destination may be locked, the sheet may be protected, the range may not fit, or Excel may be in a state that prevents the operation. Test a single copied cell in a blank, unmerged cell on an unprotected sheet. If that works, the issue is specific to the original destination or selection.

Why does Ctrl+C copy text inside a cell instead of the whole cell?
You are probably editing the cell or formula bar. Press Enter to finish the edit or Esc to cancel it, then select the cell once and copy again. On a Mac, use Command+C after leaving edit mode.

Why does copy and paste work in Excel but not between Excel and another app?
The other application, browser permissions, clipboard software, or a remote-session setting may be blocking cross-application transfer. Test another application and, if you are using a remote desktop, check whether clipboard sharing is permitted by the connection or your administrator.

Will restarting Excel delete my workbook?
Closing Excel does not normally delete a saved workbook, but unsaved changes can be lost. Save the file first and confirm that it has finished saving, especially when it is stored in a cloud location or shared folder.

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.