Excel Freezes When Copying and Pasting? Fix It

If Excel freezes or becomes unresponsive when you copy and paste, the usual cause is a conflict between the clipboard and Excel’s background processes, often triggered by large data ranges, add-ins, or corrupted formatting. The fix is to clear the clipboard, disable add-ins, and paste using the “Paste Special” options to bypass the problem.

Why Copying and Pasting Freezes Excel

Copying and pasting is a memory-intensive operation. When you copy a large range (e.g., an entire column with 1,048,576 rows), Excel stores the data plus formatting, formulas, and conditional formatting rules in the clipboard. This can consume gigabytes of RAM, especially if you have many workbooks open or the file contains complex formatting. The freeze often happens because Excel is trying to update the status bar, screen, and calculation engine simultaneously.

Another common trigger is the presence of volatile functions like OFFSET, INDIRECT, or NOW() in the pasted area. When you paste, Excel recalculates the entire workbook, which can stall if the workbook has many formulas. Additionally, clipboard managers (like Windows Clipboard History) or third-party add-ins that hook into Excel’s copy/paste events can cause conflicts.

Quick Fixes to Try First

Start with these low-risk steps; they resolve most cases:

Press Esc to cancel the marching ants (the dashed border around the copied range). This clears the clipboard and often stops the freeze.
Clear the clipboard in the Home tab > Clipboard group > the small arrow > Clear All.
Restart Excel in Safe Mode: hold Ctrl while starting Excel, or run excel /safe from the Run dialog (Win+R). If it works, an add-in is the culprit.
Turn off hardware graphics acceleration: File > Options > Advanced > Display > uncheck “Disable hardware graphics acceleration” (or check it, depending on your version).
Use Paste Special instead of Ctrl+V: right-click > Paste Special > Values (or Formulas). This avoids pasting formatting and reduces memory load.

How to Disable Add-Ins That Cause Freezes

Add-ins are a frequent cause of copy/paste freezes because they run code on every clipboard operation. To disable them:

Go to File > Options > Add-ins.
At the bottom, select “COM Add-ins” from the Manage dropdown and click Go.
Uncheck all add-ins (note which ones were checked) and click OK.
Restart Excel and test copy/paste. If it works, re-enable add-ins one by one to find the offender.

If you use Excel on a Mac, go to Tools > Add-ins and uncheck the ones you don’t need. Common problematic add-ins include Solver, Analysis ToolPak, and third-party PDF or data-import tools.

What to Do When Pasting Large Data Sets

If you’re copying thousands of rows, the freeze is often due to Excel trying to paste formatting and formulas that reference entire columns. Instead:

Copy only the used range (Ctrl+Shift+End) rather than entire columns.
Paste as values using Alt+E S V (classic) or right-click > Paste Special > Values.
Turn off automatic calculation: Formulas tab > Calculation Options > Manual. Then paste, and press F9 to recalc when done.
If you need formatting, use the Format Painter after pasting values, or paste with “Keep Source Formatting” but only if the range is small.

How to Clear Excessive Formatting That Slows Excel

Sometimes the freeze isn’t the copy/paste itself but the state of the destination sheet. Over time, sheets accumulate formatting on unused cells (e.g., if you formatted an entire column). To clean it:

Select the rows/columns you actually use.
Go to Home > Clear > Clear Formats (or use the eraser icon).
Alternatively, use the shortcut Ctrl+End to see the last used cell; if it’s far beyond your data, delete the extra rows/columns, save, and reopen.

You can also use the “Check Performance” feature in newer Excel (File > Info > Check for Issues > Check Performance) to identify cells causing slowness.

Advanced Fixes: Repair Office and Update Drivers

If none of the above work, the issue may be with the Office installation itself or your graphics driver. Try:

Repair Office: Go to Control Panel > Programs > Microsoft Office > Change > Quick Repair (then Online Repair if that fails).
Update graphics drivers: Outdated drivers can cause screen-drawing freezes during copy/paste. Check your manufacturer’s website.
Disable hardware acceleration again (some users find the opposite works after a driver update).
Check for Windows updates that might patch clipboard-related bugs.

Frequently Asked Questions

Why does Excel freeze only when I copy from another program?

When you copy from a web browser or PDF, the data often comes with rich formatting (HTML, images, etc.). Excel tries to interpret all that, which can cause a freeze. Use Paste Special > Text or Unformatted Text to avoid this.

Does the clipboard history feature cause freezes?

Yes, Windows Clipboard History (Win+V) can interfere with Excel’s clipboard. If you have it enabled, try turning it off in Settings > System > Clipboard.

Why does Excel freeze when I copy a single cell?

If a single cell freezes, it’s likely a corrupt cell or a volatile formula. Try copying the cell’s formula bar content (F2, Ctrl+A, Ctrl+C) and pasting into a new cell. Also check if the cell has data validation or conditional formatting that might be excessive.

Can a large number of conditional formatting rules cause the freeze?

Yes, conditional formatting rules are recalculated on paste. If you have hundreds of rules, each paste triggers a full re-evaluation. Use the Conditional Formatting Rules Manager to delete unused rules or convert them to static formatting.

Is there a way to copy and paste without freezing in Excel Online?

Excel Online has its own limitations; it often freezes with large ranges. Try copying smaller chunks, or use the desktop app for heavy work. Also, ensure your browser is up to date.

What if the freeze happens every time I paste, even after restarting?

Then the problem is likely the workbook itself. Try copying the data to a new workbook (File > New > Blank) and paste there. If that works, the original file may be corrupted; use File > Info > Inspect Workbook to check for issues.

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →