How to Fix Excel Lag When Dragging and Moving Cells
Question details
The user experiences significant lag and a blue loading indicator when trying to drag and drop cells in Excel, although copying and pasting works immediately.

- Product
- Microsoft 365 Excel
- Device & OS
- Windows
- Scenario
- Moving cell data to another location within the spreadsheet using the drag-and-drop method.
- Observed behavior
- Excel pauses for several seconds and displays a blue loading indicator when dragging a cell, despite Office repair and clean-boot troubleshooting having already been attempted.
Before making any system changes, create a new blank workbook and test the drag-and-drop feature to determine whether the delay happens in all workbooks or is specific to a single corrupted file.
Disable Unnecessary Excel Add-ins
Third-party add-ins can often conflict with basic Excel functions. Disabling them helps identify if a specific extension is causing the drag-and-drop lag.
Add-ins provide extra features but can sometimes severely degrade Excel's performance. Temporarily disabling all COM Add-ins is the most effective way to rule out interference.
Launch Excel, click on 'File' in the top-left corner, and select 'Options' from the bottom of the left sidebar.
In the Excel Options window, click on 'Add-ins' located in the left-hand menu.
At the bottom of the window next to 'Manage', select 'COM Add-ins' from the dropdown menu and click the 'Go...' button.
Uncheck all the active add-ins in the list and click 'OK'. Restart Excel and test if dragging cells is still slow. If the issue is fixed, re-enable your add-ins one by one to find the culprit.

Use the Open and Repair Tool
If the drag-and-drop lag is restricted to a single workbook, the file structure might be damaged. Excel's built-in repair tool can fix hidden internal errors.
Install the Latest Windows and Office Updates
Outdated software can lead to compatibility issues and performance drops. Ensuring both Windows and Microsoft 365 are fully updated can resolve known bugs affecting cell movement.
Experience Smooth Spreadsheets with WPS Office
If Microsoft Excel continues to lag, freeze, or display a loading circle during simple tasks like moving cells, consider switching to WPS Office. It provides a highly responsive, lightweight spreadsheet environment that uses fewer system resources while offering seamless compatibility with all your existing Microsoft Office files.

Frequently Asked Questions
Why does Excel show a blue loading circle when dragging cells?
The blue loading circle indicates that Excel is utilizing system resources to process background data. This usually happens if there are conflicting COM add-ins, complex conditional formatting, or high CPU usage from other programs interfering with the drag-and-drop feature.
Can conditional formatting cause Excel to lag when moving cells?
Yes. If a workbook contains extensive conditional formatting rules or volatile formulas, dragging and moving cells forces Excel to instantly recalculate these rules across the entire sheet, which can cause severe delays and freezing.
How do I know if the drag-and-drop lag is isolated to a specific file?
Create a completely new, blank workbook. Type random data into a single cell and try dragging it to a new location. If the cell moves smoothly without a delay, the problem is isolated to your original file, which may be excessively large or corrupted.
Will reinstalling Microsoft Office fix spreadsheet performance issues?
Reinstalling Office can sometimes help if the core installation files are deeply corrupted and standard repair tools have failed. However, it is usually recommended to check for updates and disable add-ins first, as those are much more common culprits for unexpected performance drops.




