Quick Answer: Excel freezes during copy-paste due to Live Preview or large clipboard data. Disable "Show Paste Options" and "Live Preview" in Excel Options > Advanced.
Symptoms
If your workbook still has unsaved changes, preserve a copy before a forced close or repair. After a crash or restart, use the unsaved Excel recovery guide before continuing troubleshooting.
Excel hangs when copying cells
Paste operation takes minutes
"Not Responding" during paste
Large files freeze on copy
Root Cause
Live Preview, animations, or clipboard holding too much data.
Fix
Method 1: Disable Live Preview
File → Options → General
Uncheck "Enable Live Preview"
Method 2: Disable Paste Options
File → Options → Advanced
Under Cut, copy, paste → Uncheck "Show Paste Options"