Excel Performance Problems

How to Fix Excel Lag When Dragging and Moving Cells

Huma Ashraf ChHuma Ashraf Ch Oct 22, 2026 870 views

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.

How to Fix Excel Lag When Dragging and Moving Cells
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 you start

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.

Solution 1Recommended

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.

1
Open Excel Options

Launch Excel, click on 'File' in the top-left corner, and select 'Options' from the bottom of the left sidebar.

2
Navigate to Add-ins

In the Excel Options window, click on 'Add-ins' located in the left-hand menu.

3
Manage COM Add-ins

At the bottom of the window next to 'Manage', select 'COM Add-ins' from the dropdown menu and click the 'Go...' button.

4
Disable and Test

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.

Disable Unnecessary Excel Add-ins
Free Microsoft Office alternative

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.

Highly optimized for performance, preventing frustrating lag during drag-and-drop and copy-paste operations.Fully compatible with Microsoft Excel formats including .xlsx, .xls, and .csv.Lightweight installation that consumes significantly fewer system resources and loads faster.Familiar user interface ensuring a smooth transition with zero learning curve.Free to use with comprehensive built-in tools for data analysis and visualization.
microsoft office alternative - wps office

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.