When arrow keys stop working in Excel, simple checks like Scroll Lock, edit mode, or frozen panes usually restore normal cell movement.
Arrow keys keep you moving fast across rows and columns, so when they stop jumping from cell to cell, work slows down straight away. Sometimes the whole sheet scrolls while the active cell stands still. In other cases nothing moves at all and you feel stuck in one corner of the grid.
Many users assume Excel is broken and start reinstalling Office or even Windows. In practice, the cause is usually a single setting, a lock key on the keyboard, or a minor glitch in Excel itself. This article shows the real reasons arrow keys misbehave and gives clear steps that bring cell movement back without drama. That saves stress when deadlines press you hard.
For searchers, the phrase arrow keys not working in excel appears often, and in many cases the solution comes from a short checklist. You will see how to match symptoms to causes, fix them in a calm order, and avoid the same freeze during busy reporting days.
Arrow Keys Not Working In Excel: Quick Diagnosis
Before you change deep settings, run a short round of checks. These handle most cases where Excel stops moving the selection with the keyboard and keep the sheet usable with minimal effort.
- Glance At Scroll Lock — Check the status bar or keyboard light and toggle Scroll Lock off if it is active.
- Leave Cell Editing Mode — Press Enter or Esc so arrow keys move between cells instead of inside a formula or text string.
- Test Another Sheet Or File — Switch tabs or open a new workbook to see whether the issue is tied to one place.
- Close And Reopen Excel — Save your work, exit Excel, reopen the file, and see whether normal navigation returns.
That first pass gives strong clues. If Scroll Lock fixes everything, you can move on with your day. If arrow keys still feel frozen, use the next sections to narrow down the cause step by step.
Why Arrow Keys Stop Responding In Excel Worksheets
Arrow keys can fail for more than one reason. Sometimes they scroll instead of moving the active cell. Sometimes they move inside text only. Sometimes they work in one area and stay frozen in another. The table below links common causes with the way they show up and the fastest fix to try.
| Cause | What It Looks Like | Quick Fix |
|---|---|---|
| Scroll Lock on | Sheet scrolls but the active cell stays in place. | Turn Scroll Lock off on the keyboard or on screen keyboard. |
| Cell editing mode | Arrow keys move the cursor inside the formula or text. | Press Enter, Esc, or click another cell to exit editing. |
| Freeze panes | Movement stops at a fixed row or column split. | Use View > Freeze Panes > Unfreeze Panes. |
| Protected sheet | Only certain cells accept selection changes. | Use Review > Unprotect Sheet, with the password if needed. |
| Add in conflict | Arrow keys behave oddly in several files on the same device. | Start Excel in safe mode and disable recent add ins. |
| Sticky or filter keys | Arrows lag, repeat, or ignore presses in Excel and other apps. | Turn off Sticky Keys and Filter Keys in keyboard settings. |
| Hardware or driver issue | Arrow keys fail in every program, not just Excel. | Test with another keyboard and refresh drivers if needed. |
Once you match the symptom to the pattern, you can target the fix instead of guessing. The next section starts with Scroll Lock and editing mode, the most frequent reasons for stuck movement.
Fix Scroll Lock And Editing Mode
Scroll Lock and editing mode create the classic case where arrow keys feel broken even when Excel works as designed. Clearing both conditions usually solves the issue for desktop users on Windows and Mac.
Turn Off Scroll Lock In Windows
- Check The Status Bar — Look along the lower edge of the Excel window and see whether the word Scroll Lock appears.
- Use The Keyboard Key — Press the Scroll Lock or ScrLk key; on some laptops you press Fn plus a key that shows ScrLk in a smaller label.
- Use The On Screen Keyboard — Press the Windows key, type On Screen Keyboard, open it, then click ScrLk to toggle Scroll Lock off.
If Scroll Lock was active, arrow keys should now switch cells again. Test by tapping the down arrow and watching whether the active cell reference near the name box changes row by row.
Turn Off Scroll Lock On Mac
- Press F14 Or A Shortcut — On extended Apple keyboards, F14 acts as Scroll Lock; some layouts need Fn plus F14 or another modifier.
- Watch The Name Box — Tap an arrow key and check the name box; if the cell code changes, Scroll Lock is off and navigation is normal.
- Use A Helper Tool If Needed — On smaller Mac keyboards, some users map Scroll Lock through a helper app or AppleScript.
Once Scroll Lock is handled, turn attention to editing mode. When a cell is active with text or a formula, arrow keys stay inside that entry instead of moving the selection.
Leave Editing Mode Cleanly
- Press Enter To Confirm — Finish the entry and let Excel move to the next cell in line with your settings.
- Press Esc To Cancel — Drop the change and return to the last saved value, then try the arrow keys again.
- Use F2 For Edits — In Options > Advanced you can clear Edit directly in cell so F2 controls entry more tightly.
If Scroll Lock and editing mode no longer hold the selection yet movement still feels blocked, the cause usually sits with freeze panes or sheet protection.
Fix Sheet Layout And Protection Problems
Sometimes arrow keys feel fine in a new workbook yet refuse to move in a specific file or tab. That pattern points to layout or protection choices, not a global setting inside Excel or Windows.
Check Freeze Panes And Split Views
- Look For Dark Lines — Scan for bold borders across the grid that show where panes are frozen at a row or column.
- Use Unfreeze Panes — Open the View tab, choose Freeze Panes, then pick Unfreeze Panes to remove all splits at once.
- Refreeze With Care — If you need frozen headers again, select the correct anchor cell before using Freeze Panes a second time.
Split views can create the sense that arrows stopped working, when in fact they simply stay inside a locked region of the sheet. Unfreezing gives you a clean slate to rebuild the layout later.
Review Sheet Protection And Cell Locking
- Watch For Protection Prompts — When edits fail or menus stay grey, open the Review tab and check whether Protect Sheet is active.
- Unprotect When You Can — Use the Unprotect Sheet command, enter the password if set, then test movement with the arrow keys again.
- Adjust Select Options — Under Protect Sheet, change options that allow selection of locked and free cells to suit your layout.
When protection and panes are out of the way, a stubborn case of arrow keys failing to move cells on one tab often clears itself. If the issue survives those moves, the next place to look is Excel options and add ins.
Check Add Ins, Accessibility, And Keyboard Behaviour
Excel add ins, advanced options, and operating system accessibility features sometimes combine in odd ways. When that happens, arrow keys can lag, skip, or ignore presses even after Scroll Lock and freeze panes are under control.
Test Excel In Safe Mode
- Start Excel With A Switch — Close Excel, press Windows plus R, type excel.exe /safe, then press Enter to open the program without add ins.
- Try Your Workbook — Open the file where navigation fails and see whether arrow keys behave better in safe mode.
- Disable Suspicious Add Ins — Inside File > Options > Add Ins, switch to Excel Add ins and COM Add ins and clear boxes for tools you rarely use.
If arrow keys work in safe mode but fail during normal startup, an add in or extension almost always sits behind the trouble. Removing or updating that tool prevents a repeat.
Adjust Accessibility Keyboard Settings
- Open Keyboard Settings — On Windows, open Settings, choose Ease of Access, then pick Keyboard from the side menu.
- Turn Off Sticky Keys — Switch off Sticky Keys so single arrow presses register normally without waiting for helper modifiers.
- Turn Off Filter Keys — Disable Filter Keys so quick taps and repeats from the arrow keys reach Excel as expected.
When accessibility settings stop holding back input, arrow keys should feel responsive again. If lag or missed presses still show up outside Excel, the keyboard itself might need closer attention.
Rule Out Keyboard Hardware Trouble
- Plug In A Spare Keyboard — Connect a USB keyboard to a laptop or desktop and wait for the system to detect it.
- Try Arrow Movement — Open a workbook and move through a range of cells using the arrows on the external keyboard.
- Compare Behaviour — If the external keyboard works while the built in one fails, switch focus to hardware repair or replacement.
If different keyboards show the same fault in many programs, the trouble can sit deeper in the operating system. In that case, a full Windows repair or a call to support may be worth the time.
Final Checks Before You Call Support
At this stage you have cleared Scroll Lock, left editing mode, removed freeze panes, checked protection, disabled risky add ins, and tried a second keyboard. In most cases, one of those moves puts navigation back on track.
Before you hand the problem to a help desk, run a short reset routine inside Excel itself. It can clean out odd settings and restore default behaviour across workbooks.
- Repair The Office Install — Use the Apps section in Windows settings or Control Panel, choose Microsoft 365 or Office, then pick a repair option.
- Reset Personal Macros And Profiles — Temporarily rename your personal macro workbook or Excel profile folders so the program rebuilds them on the next start.
- Keep Backups Of Sheets — Store a copy of long workbooks in version control or cloud storage before deep repair steps.
- Document What Worked — Note which fix helped so you can repeat it quickly the next time arrow keys not working in excel interrupts your day.
Once you know where to look and which switches to flip, a frozen arrow key stop feels less like a crisis and more like a short maintenance task. That confidence keeps attention on the numbers instead of the keyboard and reduces the chances of a future Excel slowdown.
