Fix Excel Not Pasting Data: Step-by-Step Guide

If you’re frustrated because Microsoft Excel refuses to paste data, you’re not alone. This guide walks you through the most common causes and fixes, from simple clipboard issues to deeper Excel settings, so you can get back to work quickly.

What You’ll Need

• A Windows or Mac computer with Microsoft Excel installed
• The file or data you’re trying to paste
• Access to Excel’s Options or Preferences (usually under File or the app menu)
• Administrator rights on your computer (for some fixes like repairing Office)

Step-by-Step

1. Check the clipboard and copy again. Sometimes the clipboard gets stuck. Copy the data again (Ctrl+C or Cmd+C) and try pasting (Ctrl+V or Cmd+V). If that fails, copy a small piece of text from another app (like Notepad) and paste it into Excel. If that works, the issue is with the original data, not Excel.
2. Restart Excel. Close Excel completely and reopen it. This clears temporary glitches. On Windows, make sure Excel isn’t still running in the background (check the system tray).
3. Restart your computer. A full restart clears the clipboard and resets system processes that may be interfering.
4. Check for add-ins. Third-party add-ins can block paste. Go to File > Options > Add-ins. At the bottom, select COM Add-ins and click Go. Uncheck all add-ins, click OK, and restart Excel. If pasting works, re-enable add-ins one by one to find the culprit.
5. Turn off the Paste Options button. In Excel Options, go to Advanced and under Cut, copy, and paste, uncheck Show Paste Options button when content is pasted. This has resolved some paste issues.
6. Disable hardware graphics acceleration. Go to File > Options > Advanced. Under Display, check Disable hardware graphics acceleration. Restart Excel. This fixes many display and clipboard glitches.
7. Repair Office. On Windows, go to Control Panel > Programs > Programs and Features. Select Microsoft Office and click Change. Choose Quick Repair first; if that doesn’t work, try Online Repair. On Mac, you can reinstall Office from the Microsoft website.
8. Update Excel. Make sure you have the latest updates. On Windows, go to File > Account > Update Options > Update Now. On Mac, go to Help > Check for Updates.
9. Try pasting with different options. Right-click and choose Paste Special > Values or Text. Sometimes the paste fails because of formatting conflicts. If that works, you can adjust the format later.
10. Check for protected sheets or workbooks. If the sheet is protected, paste may be disabled. Go to Review > Unprotect Sheet (if you have the password). Also check File > Info > Protect Workbook for any restrictions.
11. Clear the clipboard history. On Windows, press Win+V to open clipboard history. If it’s full, clear it. Also, in Excel, go to Home > Clipboard (small arrow) and click Clear All.

Common Mistakes

• Copying from a web page with complex formatting. The HTML may contain elements Excel can’t handle. Use Paste Special > Text to strip formatting.
• Not restarting after disabling add-ins. Some add-ins only unload after a full restart.
• Editing a cell while trying to paste. If you’re in edit mode (the cell shows a blinking cursor), paste may not work as expected. Press Enter or Esc first.
• Copying from a program that doesn’t put data on the clipboard properly. Some older or niche apps copy in a format Excel can’t read. Try copying as plain text first.

Tips

• Use Ctrl+Alt+V (Windows) or Cmd+Ctrl+V (Mac) to open Paste Special quickly.
• If you frequently paste from the same source, consider using a macro to automate the paste with specific settings.
• Keep Excel updated to avoid bugs that are fixed in newer versions.
• If you’re on a corporate computer, group policies may disable paste. Contact your IT department.

Troubleshooting

If the steps above don’t solve the issue:

• Try a different file. If pasting works in a new workbook, the issue is with the specific file. Check for corruption or protected views.
• Check if the problem happens in other apps. If copy/paste is broken everywhere (e.g., in Word, Notepad), it’s a system clipboard issue. Restart your computer or run a clipboard manager to reset it.
• Run Excel in Safe Mode. Hold Ctrl while starting Excel (Windows). If it works in Safe Mode, an add-in or startup file is the cause. Disable them one by one.
• Reset Excel settings. As a last resort, you can reset Excel’s registry settings (Windows) or delete its preferences (Mac). This will reset all customizations, so back up your settings first.
• Check for third-party clipboard managers. Apps like Ditto or ClipboardFusion can interfere with Excel. Temporarily disable them.

Frequently Asked Questions

Why does Excel paste only values and not formulas?

This happens when you use Paste Special > Values, or when the source cell is formatted as text. To paste formulas, use Paste Special > Formulas or copy from a cell that contains a formula.

Why is the paste option grayed out?

The paste option is grayed out when the sheet is protected, the workbook is shared, or you’re in edit mode. Unprotect the sheet, remove sharing, or press Esc to exit edit mode.

Can I paste data without formatting?

Yes, use Paste Special > Values or Text. This pastes only the raw data, removing any fonts, colors, or borders.

Why does pasting crash Excel?

This can be due to large amounts of data, conflicting add-ins, or a corrupted clipboard. Try pasting in smaller chunks, disable add-ins, and restart Excel. If the problem persists, repair Office.

Does this work on Excel for Mac?

Most steps are similar, but some options are in different locations. For example, add-ins are under Tools > Add-ins. The repair process is different—you may need to reinstall Office.

What if I’ve tried everything and it still doesn’t paste?

If none of the fixes work, consider reinstalling Microsoft Office completely. Also, check if a system-level clipboard issue exists by testing copy/paste in other applications. If it’s only Excel, a fresh reinstall usually resolves it.

Related

• Offline PC Gaming: Play Legal Games Without Internet
• iPhone Camera Settings for Telephoto Lens Attachments
• Fix Notepad Not Opening on Windows 11