When the arrow keys in Excel are not working, the sheet usually scrolls instead of the highlighted cell moving. That is the classic sign of Scroll Lock being on. Look for SCRL in the status bar at the bottom of the window, press the Scroll Lock key once, and the arrows go back to moving between cells.
Quick Answer
Press Scroll Lock, or on a laptop without one, open the on-screen keyboard and click ScrLk. If SCRL is not showing, check Sticky Keys, add-ins and sheet protection in that order. A keyboard fault is the last suspect, and a plain replacement board costs around R350 to R600.
🔒 Scroll Lock: the usual suspect
With Scroll Lock on, the arrows move the whole view rather than the active cell. Excel shows SCRL in the status bar when this happens. If you do not see SCRL, right-click the status bar and tick Scroll Lock so Excel displays it.
No Scroll Lock key on your laptop?
Many compact laptops drop the key. Type "on-screen keyboard" into Windows search, open it, and click ScrLk to turn it off. Some models hide Scroll Lock behind Fn plus another key, so read the keycap legends.
⚙️ Settings that quietly change arrow behaviour
- Sticky Keys: pressing Shift five times can enable it. Switch it off under Settings, Accessibility, Keyboard.
- Edit mode: if you press F2 or double-click a cell, the arrows move the cursor inside the cell. Press Enter or Esc to leave it.
- Protected sheets: with "Select locked cells" unticked in protection, the arrows cannot land on locked cells. Use Review, then Unprotect Sheet on the file that misbehaves.
- Frozen panes and filters: these can make movement look strange but do not block the arrows.
Quick checks that take seconds
Press Esc a couple of times to leave any hidden edit mode. Click once on a plain cell, then press the Down arrow. If the highlight moves one row, the arrows are fine and the earlier problem was a mode. Also try Ctrl plus the arrow keys, which jumps to the edge of your data. If that works while plain arrows fail, Scroll Lock is almost certainly the cause.
Excel on the web and phone
On Excel for the web, the browser can capture arrow keys for page scrolling, especially if focus is outside the grid. Click inside a cell first. On an Android tablet with a Bluetooth keyboard, make sure the board is paired and the app is in focus, since the on-screen keyboard can hide the fact that the physical one has disconnected.
🧩 Add-ins and a clean start
An add-in can intercept key presses. Hold Ctrl while opening Excel to start in Safe Mode. If the arrows work there, go to File, Options, Add-ins, choose COM Add-ins at the bottom, and disable them one at a time until the culprit shows up.
If a certain workbook is the only one that misbehaves, copy its contents into a fresh file. Macros with an OnKey command in the original can reassign the arrow keys without you knowing.
🛠️ Is it Excel or the hardware?
Press the arrows in Notepad or inside a browser address bar. If they work there, your keyboard is healthy and only Excel needs attention. If the arrows fail everywhere, test the board on another PC, try another USB port, and consider a new one. A gaming keyboard is overkill for spreadsheets, but the cheapest gaming keyboard list is a handy way to see simple, hard-wearing models for a student desk.
Frequently Asked Questions
Why do my arrow keys move the whole sheet in Excel?
Scroll Lock is on. Excel then scrolls the window rather than moving the active cell. Look for SCRL in the status bar and press Scroll Lock once to clear it.
My laptop has no Scroll Lock key. What now?
Open the on-screen keyboard from Windows search and click ScrLk. Compact laptops often hide the function behind Fn plus another key, so check the keycap legends.
Could a protected sheet stop the arrows?
A protected sheet with cell selection locked can stop movement. Try another workbook first, then use Review and Unprotect Sheet on the file that misbehaves.
Do Excel add-ins ever break arrow keys?
Occasionally. Hold Ctrl while opening Excel to start in Safe Mode. If the arrows work there, disable add-ins one at a time until the culprit shows itself.
How do I tell Excel from a hardware fault?
Press the arrows in Notepad or a browser address bar. If they work there, the keyboard is healthy and only Excel settings need attention.
Do shared student lab PCs cause this more often?
Shared machines in lab and res room setups get left with Scroll Lock on or odd accessibility settings, so check the status bar before a long assignment.
Ready to move through your spreadsheets with ease?
Take a look at the keyboard range at Evetech if yours turns out to be faulty, and pick a board with a full set of arrow keys for long sessions in Excel.