Stop Excel from Centering the Worksheet View After Pasting
Question details
The user wants Excel to keep the working area in view after pasting data near the edge of the screen.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Pasting data into a cell near the edge of the visible worksheet.
- Observed behavior
- Excel moves or centers the worksheet view on the pasted cell, requiring the user to scroll back. The behavior also occurs in new blank workbooks.
Test the same paste in a new blank workbook and note whether the view moves. The Safe Mode and Office repair instructions below apply to Windows.
Test Excel in Safe Mode and disable suspected add-ins
Use Safe Mode to check whether an add-in is causing the worksheet view to move after pasting.
Close Excel, press Windows+R, enter excel /safe, and select OK.
Open a blank workbook, paste data near the edge of the visible worksheet, and check whether the view still moves.
If the problem does not occur in Safe Mode, restart Excel normally. Go to File > Options > Add-ins, select COM Add-ins in the Manage list, and select Go.
Clear the checkbox for a suspected add-in, such as Acrobat or PlanSwift, select OK, and restart Excel to test the paste again. Repeat with other add-ins as needed.
If necessary, return to File > Options > Add-ins, choose Excel Add-ins in the Manage list, and select Go to review and test those add-ins.
Run an Online Repair of Microsoft Office
Repair Office if the behavior continues in Safe Mode or disabling add-ins does not resolve it.
Keep worksheet headings visible with Freeze Panes
Use this workaround to keep important rows or columns visible while you investigate the scrolling behavior.
Work with spreadsheets in WPS Office
WPS Office is a free, lightweight, easy-to-use alternative with a familiar spreadsheet interface. Open compatible Excel files in WPS Spreadsheet for a straightforward move from Microsoft Office. It does not repair Excel or its add-ins.

Frequently Asked Questions
How do I check whether an add-in causes the view to move?
On Windows, close Excel, press Windows+R, and run excel /safe. If pasting works normally in Safe Mode, restart Excel and test add-ins through File > Options > Add-ins.
Which add-ins should I test first?
Start with add-ins installed on the affected computer, such as Acrobat or PlanSwift. Under File > Options > Add-ins, choose COM Add-ins and select Go, then disable and test them one at a time.
Why does the worksheet move even in a blank workbook?
A problem that affects new workbooks may be related to Excel's environment rather than a particular file. Test Safe Mode first, then consider an Office Online Repair if the behavior persists.
Will Freeze Panes stop Excel from scrolling after a paste?
Not necessarily. View > Freeze Panes keeps chosen rows and columns visible, but the unfrozen part of the worksheet can still move.
How do I undo frozen panes?
In Excel, select View > Freeze Panes > Unfreeze Panes.




