Excel on Windows: switch off Scroll Lock
- Press the physical Scroll Lock or ScrLk key once if it is enabled.
- Without that key, open Start → Settings → Accessibility → Keyboard → On-screen keyboard, then click ScrLk.
- 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
- 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.
- A MacBook without F14 may need an external keyboard that supplies the key. Do not assume a made-up Fn shortcut is equivalent.
- Return focus to the worksheet and test a single arrow press.
If arrows still do not select another cell
- Press Enter to commit a cell edit, or Esc to cancel it. Click a normal worksheet cell before testing again.
- Close a dropdown or dialog that has focus. Compare a new workbook if only one file behaves differently.
- Try arrows in a plain text app. If they also fail there, follow general keyboard troubleshooting rather than changing Excel settings repeatedly.