2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Copying a cell in Excel spikes CPU to over 50%

Our take

If you've experienced high CPU usage while copying cells in Excel, you're not alone. This issue can spike CPU usage above 50% for several seconds, even with empty cells, and it often occurs in specific files. The culprit is the animated "marching ants" effect that Excel uses, which requires constant graphics calculations. If your display scaling is set to 125%, it complicates these calculations, leading to performance issues. Fortunately, there are three effective solutions to resolve this problem and restore smooth operation.

Sharing this because it took a long time to figure out and I couldn't find this specific cause documented anywhere.

The issue: Copying any cell in certain Excel files would spike the CPU to 50%+ for half a minute. Didn't matter if the copied cell was empty. Only happened on some files.

What was causing it: When you copy a cell in Excel it draws those animated dashes around the copied cell (the "marching ants"). That animation is a loop that keeps redrawing constantly until you press Escape or paste.

If you have your display set to 125% scaling, Windows can't do clean math to scale graphics, so it has to do expensive interpolation on every single graphics call. Excel's marching ants fires a lot of those graphics calls per second, and the CPU has to work hard to do the calculations.

I found 3 ways to fix it:

  1. Set display scaling to 100% - simplest fix, but text gets smaller
  2. Disable the marching ants - in registry set HKCU\Control Panel\Desktop\WindowMetrics\MinAnimate to 0. No animation = no loop = no spike.
  3. Tell Excel to handle its own scaling - right-click EXCEL.EXE → Properties → Compatibility → check "Override high DPI scaling behavior" → set "Scaling performed by" to Application. This is the cleanest fix - keeps 125% scaling and keeps marching ants, no spike.

Hope this helps someone.

submitted by /u/onupirat
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article

Tagged with

#Excel compatibility#Excel alternatives for data analysis#Excel alternatives#no-code spreadsheet solutions#rows.com#natural language processing for spreadsheets#generative AI for data analysis#real-time data collaboration#real-time collaboration#Excel#CPU#copying cell#marching ants#display scaling#graphics calls#expensive interpolation#scaling behavior#registry#high DPI#compatibility settings