Excel Performance Problems

How to Prevent Excel from Centering the Active Cell After Pasting

Anum MushtaqAnum Mushtaq Nov 3, 2026 871 views

Question details

The user wants to stop Excel from automatically adjusting the worksheet view to center the pasted or active cell on the screen.

How to Prevent Excel from Centering the Active Cell After Pasting
Product
Microsoft Excel
Device & OS
not provided
Scenario
Pasting data into an Excel worksheet or moving between active cells.
Observed behavior
Excel automatically scrolls and shifts the worksheet view so the pasted or active cell is centered on the screen, causing a jarring disruption to the user's workflow.
Before you start

Save your current work and verify if this automatic scrolling behavior occurs in all your Excel files or if it is isolated to a specific workbook.

Solution 1Recommended

Disable COM Add-ins via Safe Mode

Running Excel in Safe Mode helps determine if a third-party add-in is causing the screen to center on the active cell. Disabling conflicting COM add-ins can resolve the issue.

Often, background utilities or specific add-ins like Solver interact poorly with the clipboard, causing Excel to aggressively reposition the active cell into the center of the display.

1
Launch Excel in Safe Mode

Close Excel completely. Press the Windows key + R to open the Run dialog, type 'excel /safe', and press Enter.

2
Test the Paste Behavior

Try copying and pasting data in Safe Mode. If the screen no longer jumps to the center, an add-in is likely the culprit.

3
Access Add-in Settings

Go to File > Options > Add-ins. At the bottom of the window, change the 'Manage' dropdown to 'COM Add-ins' and click 'Go...'.

4
Disable Conflicting Add-ins

Uncheck all add-ins in the list to disable them, click OK, and restart Excel normally to verify the issue is resolved.

Disable COM Add-ins via Safe Mode
Isolate the Problem: If disabling all add-ins fixes the issue, you can re-enable them one by one to find out exactly which one causes the centering behavior.
Free Microsoft Office alternative

Switch to WPS Office for a Smoother Spreadsheet Experience

If Microsoft Excel continues to disrupt your workflow with automatic screen centering or unresolvable add-in conflicts, consider switching to WPS Office. It provides a highly compatible, lightweight, and completely free alternative for all your spreadsheet tasks without these frustrating scrolling bugs.

  1. 1. Download the Installer: Visit the official WPS Office website and click the free download button.
  2. 2. Install WPS Office: Run the lightweight installer and follow the simple on-screen instructions to set up the software.
  3. 3. Open Your Workbooks: Launch WPS Spreadsheet and directly open your existing Excel files to continue working seamlessly.
Stable spreadsheet performance without jarring auto-scrolling or centering bugsSeamless compatibility with Microsoft Excel formats (.xlsx, .xls, .csv)Familiar user interface requiring zero learning curveLightweight installation that runs smoothly on almost any device
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel screen jump when I copy and paste?

This usually happens due to active COM add-ins, specific zoom settings, or hidden objects on the worksheet that force Excel to reposition the active cell into the center of your screen to ensure the pasted area remains visible.

Does freezing panes affect how Excel centers the active cell?

Yes, if you have frozen panes enabled, pasting data near the frozen boundaries can sometimes trigger Excel to adjust the view abruptly. Unfreezing panes via the View tab > Freeze Panes can occasionally stop this jumping behavior.

How do I turn off Scroll Lock if it is causing scrolling issues?

If your arrow keys are scrolling the entire page rather than moving between cells, Scroll Lock is likely enabled. You can turn it off by pressing the 'ScrLk' key on your keyboard or by using the Windows On-Screen Keyboard.

Can a corrupted workbook cause abnormal pasting behavior?

Yes. If the auto-centering behavior only occurs in one specific file, the workbook might be corrupted or overly complex. Try copying the necessary data and pasting it into a brand new blank workbook to see if the issue is resolved.