How to Prevent Excel from Centering the Active Cell After Pasting
Question details
The user wants to stop Excel from automatically adjusting the worksheet view to center the pasted or active cell on the screen.

- 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.
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.
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.
Close Excel completely. Press the Windows key + R to open the Run dialog, type 'excel /safe', and press Enter.
Try copying and pasting data in Safe Mode. If the screen no longer jumps to the center, an add-in is likely the culprit.
Go to File > Options > Add-ins. At the bottom of the window, change the 'Manage' dropdown to 'COM Add-ins' and click 'Go...'.
Uncheck all add-ins in the list to disable them, click OK, and restart Excel normally to verify the issue is resolved.

Run an Office Repair and Update Windows
If Safe Mode does not resolve the automatic centering issue, repairing the Office installation and updating the operating system can fix underlying software glitches.
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. Download the Installer: Visit the official WPS Office website and click the free download button.
- 2. Install WPS Office: Run the lightweight installer and follow the simple on-screen instructions to set up the software.
- 3. Open Your Workbooks: Launch WPS Spreadsheet and directly open your existing Excel files to continue working seamlessly.

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.




