Excel Performance Problems

Stop Excel from Centering the Worksheet View After Pasting

Chanuka GeekiyanageChanuka Geekiyanage Nov 18, 2026 868 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Open Excel in Safe Mode

Close Excel, press Windows+R, enter excel /safe, and select OK.

2
Repeat the paste

Open a blank workbook, paste data near the edge of the visible worksheet, and check whether the view still moves.

3
Review COM add-ins

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.

4
Test add-ins individually

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.

5
Check Excel add-ins

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.

Interpret the test: If the view still moves in Safe Mode, an add-in is less likely to be the cause. Try repairing Office.
Free Microsoft Office alternative

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.

Paste and edit data in a familiar spreadsheet interfaceOpen and save compatible Microsoft Excel XLSX and XLS filesUse a free, lightweight Office alternativeMove existing spreadsheet files into WPS for continued editing
microsoft office alternative - wps office

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.