How to Stop Excel from Scrolling when Pasting

%3CLINGO-SUB%20id%3D%22lingo-sub-2103690%22%20slang%3D%22en-US%22%3EHow%20to%20Stop%20Excel%20from%20Scrolling%20when%20Pasting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2103690%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20copy%20a%20cell%20on%20the%20left%20side%20of%20a%20spreadsheet%20and%20paste%20into%20a%20cell%20on%20the%20right%20side%2C%20the%20whole%20spreadsheet%20scrolls%20right.%26nbsp%3B%20Sometimes%20it%20also%20scrolls%20up%20or%20down.%26nbsp%3B%20It's%20almost%20like%20Excel%20wants%20the%20pasted%20cell%20to%20be%20in%20the%20middle%20of%20the%20display.%26nbsp%3B%20It%20does%20it%20in%20the%20other%20direction%20too.%26nbsp%3B%20Is%20there%20a%20setting%20that%20I%20have%20somehow%20accidentally%20turned%20on%20that%20forces%20the%20display%20location%20of%20any%20cell%20that%20that%20control-V%20is%20used%20in%3F%26nbsp%3B%20I%20spend%20all%20day%20chasing%20my%20spreadsheets%20around.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2103690%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

When I copy a cell on the left side of a spreadsheet and paste into a cell on the right side, the whole spreadsheet scrolls right.  Sometimes it also scrolls up or down.  It's almost like Excel wants the pasted cell to be in the middle of the display.  It does it in the other direction too.  Is there a setting that I have somehow accidentally turned on that forces the display location of any cell that that control-V is used in?  I spend all day chasing my spreadsheets around. 

5 Replies

Hi @DavidThorpe 

 

I don't think there's a setting, but I think if you slightly adjust the column width of where you are pasting prior to pasting the jumping should stop  (it did when I just checked - I'm using Excel 365 Desktop)

 

 

@Wyn Hopkins 

I tried that, it still did it.  Here is an example of what it's doing. 

I'm copying the red cell (control c) and pasting it into the yellow cell (control v)...

DavidThorpe_9-1611843017882.png

 

It scrolled to the right.  The blue cell is where the curser was after it scrolled.

DavidThorpe_10-1611843070090.png

 

If I paste into any cell below the yellow one it scrolls.  If I paste into any square above the yellow one it doesn't scroll. 

 

 

 

 

 

 

 

 

Very odd.
Does changing the screen zoom (down the bottom right) have any effect?
I can't reproduce what's happening for you, never seen it before.

Might be worth running a repair (if it's Office 365 )

@Wyn Hopkins 

Thanks for the response.  I zoomed out to the point that I can't read the text and it still does it.  It is Office 365, repairing didn't fix it and neither did re-installing.  

Hi @DavidThorpe 

 

I'd recommend you send a frown (via File > Feedback, and include a link to this thread)

Hopefully someone in the Excel team would investigate.

 

My last random guess suggestion would be to try ticking the box to "Disable Hardware Graphics acceleration".  That setting sometimes causes odd results.

image.png