Forum Discussion

JY32932's avatar
JY32932
Copper Contributor
Apr 16, 2020

Slow Performance when Moving While Editing a Cell

Hi Everyone,

 

Thanks in advance for your help. The best way to explain this issue is with a screen capture which I have attached. With that said, I have noticed for years that my excel gets extremely laggy in one particular instance. When I am editing the contents of a cell and use the arrow keys to move a somewhat large distance around the sheet, that movement becomes incredibly laggy. This issue becomes particularly pronounced when using the arrow keys to 'scroll' to a portion of the sheet that is beyond the immediate view. Note, I'm not talking about scroll lock, but when just holding the arrow key and the active cell gets to the top/bottom of the viewable portion which causes the sheet to scroll.  Again, watching the video will probably make this a lot more clear. 

 

I'm curious to see if anyone doesn't have this issue. I've noticed it on multiple computers as well as fresh installs of Windows and Office. 

 

Just to clarify a few other things. While this applies when a sheet is longer than the viewable area, I'm not talking about particularly long, complicated sheets. This happens with 100 rows or so and just a few sum formulas, as the video shows. Additionally, this particularly computer has  an i7-8750H and 32GB of ram, so computing power certainly shouldn't be the bottleneck. Additionally, what I'm doing in the video is basically just holding the arrow key in various directions. When things stutter, I'm holding the arrow key down continuously and just switch directions when I get to the end of that area. The stuttering the video shows accurately reflects what it looks like in real life. 

2 Replies

  • JY32932's avatar
    JY32932
    Copper Contributor

    Any ideas? I'm running the 64 bit version of office. 

Resources