Why Do Arrow Keys Move the Screen in Excel Worksheet?
One minute, you are happily navigating around your spreadsheet and the next, whenever you press the right arrow key, your screen scrolls right.

There are a number of handy features which help navigate throughout Excel and can be of real use. unless you have turned these on without realising and Excel is not working as is should!


Scroll lock option

Just like the Extend Selection feature, there is a scroll lock option in Excel, which allows you to use arrow keys, rather than the mouse. With Extend selection, you can press F8 and using the arrow keys will not just move your selected cell around the screen but will also highlight cells. The Scroll lock feature, when turned on, allows you to move the screen around with the arrow keys but does not move the selection.

The very simply resolution is, you have scroll lock turned on.

One way to see if this is turned on, is to look at the status bar at the bottom-left of your screen. If you see Scroll Lock, then the feature is enabled.

Scroll lock option in Excel

To get back to using the arrow keys for selecting cells, simply press the scroll lock key on your keyboard and using the arrow keys, will once again mean that you are moving the selected cell around.

Help files in Excel

Using the help files in Excel are very handy, particularly to identify keyboard shortcuts. If you use the Help feature (which is now the "tell me what you want to do." option on the Ribbon, in the 2016 version of Office), you can search for shortcuts. The results will list a number of features you may not have known about before and even better, how to turn them off again once you have used them!