Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
My Arrow Keys Dont Move From Cell To. Click that button once and you should move out of scroll lock mode. If I then hit the LEFT arrow key nothing happens.
Here I am just using the on screen keyboard to demonstrate however if you cannot find the scroll lock key or its not working you can also use the on scree. According to your description it seems that you pressed SCROLL LOCK labeled as ScrLk key by accident which will cause the entire worksheet to be moved when using the arrow keys you can check the status bar in the lower-left corner in Excel to see if Scroll Lock is displayed. Right-click Excels bottom status bar and put a check beside Scroll Lock to get a scroll lock indicator on the left side of the status bar.
When the Scroll key locks pressing any arrow key on the keyboard will move the entire worksheet instead of a single cell.
On my keyboard its on the upper-right hand corner near the INS DEL HOME and END buttons and its labelled SCROLL LOCK. To use the arrow keys to move between cells you must turn SCROLL LOCK off. If not try re-plugging the keyboard. TAB to move forward to the right one cell.