Forum Discussion

DavidThorpe's avatar
DavidThorpe
Copper Contributor
Jan 27, 2021

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...
excel
Wyn Hopkins's avatar
Wyn Hopkins
MVP
Jan 28, 2021

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)

 

 

  • DavidThorpe's avatar
    DavidThorpe
    Copper Contributor
    Jan 28, 2021

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

     

    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. 

     

     

     

     

     

     

     

     

    • Wyn Hopkins's avatar
      Wyn Hopkins
      MVP
      Jan 30, 2021
      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 )
      • DavidThorpe's avatar
        DavidThorpe
        Copper Contributor
        Jan 30, 2021

        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.  

Resources