If you cannot move cells with the arrow keys and the screen scrolls, the scroll lock may be set.
Please refer to the following article on how to unlock the scroll lock.
How to remove scroll lock in Excel shortcut
If you are in Formula Entry mode in Excel, you cannot move to another cell by pressing the arrow keys. Use the following method to remove Formula Entry mode.
B2 is in Formula Entry mode.
Press Enter to confirm the formula and the arrow keys become available.
If using the arrow keys results in a range selection instead of moving cells, Extended Selection mode is enabled. Use the following method to disable Extended Selection mode.
The sheet is in Extended Selection mode and using the arrow keys results in a range selection.
Press F8 cancels the Extended Selection mode and allows moving cells with the arrow keys.
Please send us your comments on this article.