Arrow keys not working in Excel

If arrow keys scroll the worksheet instead of selecting another cell, turn off Scroll Lock. If they move inside a formula, finish or cancel cell editing first.

Excel on Windows: switch off Scroll Lock

  1. Press the physical Scroll Lock or ScrLk key once if it is enabled.
  2. Without that key, open Start → Settings → Accessibility → Keyboard → On-screen keyboard, then click ScrLk.
  3. Check the Excel status bar. If Scroll Lock is hidden, right-click the status bar and enable its Scroll Lock indicator.

Excel on Mac: use the supported F14 shortcut

  1. Use Shift+F14 to toggle Scroll Lock with a keyboard that provides F14. Microsoft notes that some keyboard types use Control, Option or Command instead of Shift.
  2. A MacBook without F14 may need an external keyboard that supplies the key. Do not assume a made-up Fn shortcut is equivalent.
  3. Return focus to the worksheet and test a single arrow press.

If arrows still do not select another cell

  1. Press Enter to commit a cell edit, or Esc to cancel it. Click a normal worksheet cell before testing again.
  2. Close a dropdown or dialog that has focus. Compare a new workbook if only one file behaves differently.
  3. Try arrows in a plain text app. If they also fail there, follow general keyboard troubleshooting rather than changing Excel settings repeatedly.

Check the result

In a worksheet, press Right once: the selected cell should move one column. Compare arrow press/release events in the tester only if they also fail outside Excel.