Forum Discussion
How to Stop Excel from Scrolling when Pasting
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.