It's actually easier than you think
How to Fix: Arrow Keys Not Working in Excel
When working on an Excel spreadsheet, the best way to move between cells is to use the arrow keys on your keyboard. With these keys available for each direction, you can easily move from one cell to another with a single key press.
Sometimes it happens that these arrow keys do not work in Excel. In some cases, they even take you to the next worksheet instead of the next cell in the row. If you are frustrated by this behavior, you probably want to know how to fix it.
Fixing the problem of arrow keys not working in Excel is actually easier than you might think. In most cases, you are just one keystroke away from making the keys do what they are supposed to do.