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...
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.