Forum Discussion
How to Stop Excel from Scrolling when Pasting
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.
15 Replies
DavidThorpe
Try freezing the top row or the first column. This happened to me a lot too but what normally fixes it is freezing a row or column. I normally freeze the top row since my spreadsheets are always scrolling back up. Go to View > Freeze Panes > Freeze Top Row
Hope this helps!I have the same issue. Freezing the top row works, but that is an obnoxious work around because I don't always want to freeze rows, but I will almost always be using copy/paste on all work I do. Seems like there should be another option to prevent the jumping around, especially if the freeze rows prevents this from happening.
danita357
I understand but unfortunately at this time that's the only work around I've come across. If you figure out another way feel free to let us know. Personally, I utilize freeze panes a lot so it's actually beneficial for me but I also get that not everyone will want to do this. There needs to be some sort of copy/paste scroll lock button we can check/uncheck to prevent this from happening.
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)
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)...
It scrolled to the right. The blue cell is where the curser was after it scrolled.
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 )
