When in Excel arrow keys not working is the problem, Scroll Lock is the usual cause: with it on, the arrows scroll the sheet instead of moving the selected cell. Press the ScrLk key, or turn it off with the Windows On-Screen Keyboard if your keyboard has no such key. If that is not it, check for Edit mode, Num Lock, a protected sheet or an add-in.
Why Are My Arrow Keys Not Working in Excel?
Your arrow keys stop moving between cells in Excel because something has changed what those keys do, most often Scroll Lock. Use this table to match the symptom to the cause before you start changing settings.
| What you see | Likely cause | Quick fix |
|---|---|---|
| The whole sheet scrolls, but the selected cell stays put | Scroll Lock is on | Press ScrLk, or use the On-Screen Keyboard |
| The cursor moves inside the cell's text | The cell is in Edit mode | Press Enter or Esc, then use the arrows |
| Number pad arrows type numbers | Num Lock is on | Press Num Lock, or use the main arrow keys |
| The selection skips some cells | The sheet is protected | Unprotect the sheet if you are allowed to |
| Arrows fail only in Excel, even with Scroll Lock off | An add-in or a damaged workbook | Start Excel in safe mode to test |
| Arrows fail in every app | Keyboard, Fn lock or driver problem | Test in Notepad and check the keyboard |
How Do You Turn Off Scroll Lock in Excel?
You turn off Scroll Lock by pressing the Scroll Lock key, often labelled ScrLk, once. Microsoft's guide to turning off Scroll Lock notes that Excel shows the words Scroll Lock in the status bar at the bottom of the window when it is on.
Scroll Lock is a keyboard setting, not an Excel setting. That has an effect people find confusing: the state is held by Windows and the keyboard, so pressing ScrLk in another app, or a stray key combination on a laptop, can switch it on and change Excel's behaviour without you opening Excel at all.
On many laptops the key is a secondary function printed on another key, so you may need to hold Fn while pressing it. Check your manufacturer's key legend if the label is not obvious.
What If Your Keyboard Has No Scroll Lock Key?
If your keyboard has no Scroll Lock key, use the Windows On-Screen Keyboard, which includes a ScrLk button that toggles the same setting.
- Open Start → Settings → Accessibility → Keyboard (on Windows 10, Settings → Ease of Access → Keyboard).
- Turn on On-screen keyboard. You can also press Windows + Ctrl + O to open it directly.
- Click the ScrLk button. It is highlighted when Scroll Lock is on and returns to normal when it is off.
- Close the On-Screen Keyboard and return to Excel. The Scroll Lock label should disappear from the status bar.
How Do You See If Scroll Lock Is On?
You can see whether Scroll Lock is on by looking at Excel's status bar, but only if the indicator is enabled there. Microsoft notes that if Scroll Lock is on but not shown, you can switch the indicator on.
- Right-click anywhere on the status bar at the bottom of the Excel window.
- In the Customize Status Bar list, tick Scroll Lock.
- While you are there, tick Num Lock and Caps Lock too, so you can spot all three at a glance.
The status bar has more useful hidden options, such as quick totals and averages for selected cells. Our list of hidden Microsoft Office productivity features covers several of them.
What Else Stops Arrow Keys Moving Between Cells?
If Scroll Lock is off and the problem remains, the cause is usually Excel's current mode, sheet protection or an add-in.
Edit mode
When you double-click a cell or press F2, Excel enters Edit mode and the status bar shows Edit. In this mode the arrows move the text cursor inside the cell instead of moving to the next cell. Press Enter to keep your change or Esc to cancel it, and the arrows work normally again.
Protected sheets
A protected sheet can block selection of locked cells. Excel then skips over those cells, which looks like the arrow keys are broken. Go to Review → Unprotect Sheet if you own the file or have the password; otherwise ask the person who protected it.
Frozen panes and hidden rows
Frozen panes do not stop the selection moving, but the frozen area stays still, which can make movement hard to see near the top of the sheet. Hidden or very narrow rows and columns have a similar effect. If you use frozen panes, our guide on how to freeze the top two rows in Excel shows how to set and remove them cleanly.
Add-ins
Some add-ins capture keyboard input. To test, close Excel, then hold Ctrl while you open it and confirm that you want to start in safe mode. If the arrows work in safe mode, go to File → Options → Add-ins, choose COM Add-ins from the Manage list, select Go, and clear the add-ins one at a time until you find the culprit.
Why Are Arrow Keys Not Working on a Laptop?
If the arrow keys fail on a laptop in every app, not just Excel, the problem is the keyboard or its settings rather than Excel. Check these in order.
- Open Notepad and press the arrow keys. If the cursor does not move there either, Excel is not the cause.
- Look for an Fn Lock key or light. Some laptops swap the arrow keys with Home, End, Page Up and Page Down when Fn Lock is on.
- If you use the number pad arrows, press Num Lock to switch them from numbers to arrows.
- Open Device Manager → Keyboards, right-click the keyboard and choose Update driver, or restart to reload it.
- Try an external USB keyboard. If it works, the built-in keyboard may need service.
A Common Mistake We See
People often repair or reinstall Office to fix arrow keys, when the cause is simply Scroll Lock left on by a keyboard shortcut. Reinstalling takes time and does not change the Scroll Lock state, because Windows, not Excel, holds it. Check the status bar first.
If Excel is misbehaving in more serious ways, such as crashing when you open one particular workbook, the file itself may be damaged. Our guide to repairing a corrupted Excel file covers Excel's built-in Open and Repair tool. And if a repair or reinstall of Office is genuinely needed, a genuine licence makes reactivation straightforward.
Frequently Asked Questions
Why do my arrow keys scroll instead of moving cells in Excel?
Scroll Lock is on. With it on, the arrow keys move the visible area of the sheet while the active cell stays where it is. Press the ScrLk key once, or use the ScrLk button on the Windows On-Screen Keyboard. The Scroll Lock label in Excel's status bar disappears when it is off.
How do I unlock arrow keys in Excel without a Scroll Lock key?
Open the Windows On-Screen Keyboard with Windows + Ctrl + O, or from Settings → Accessibility → Keyboard, and click its ScrLk button. That toggles the same Scroll Lock setting as a physical key. Close the On-Screen Keyboard afterwards and test the arrows in your worksheet again.
Why are arrow keys not working in Excel but working elsewhere?
That points to Scroll Lock, Edit mode, a protected sheet or an Excel add-in, because other apps ignore those. Check the status bar for Scroll Lock or Edit first. If neither shows, start Excel in safe mode by holding Ctrl as it opens, and disable add-ins one at a time.
What does Scroll Lock actually do in Excel?
Scroll Lock changes the arrow keys from moving the active cell to scrolling the worksheet window. It is useful when you want to look at another part of a large sheet without losing your place. Most people never need it, which is why it is easy to switch on accidentally and not notice.
Does Excel for Mac have Scroll Lock?
Excel for Mac also supports Scroll Lock, but Mac keyboards rarely have a key labelled for it, and the key combination depends on your keyboard. Microsoft's Scroll Lock guide covers Windows. On a Mac, check the status bar indicator and your keyboard's documentation before assuming Excel itself is faulty.
Why do my arrow keys type numbers?
You are using the arrow keys on the number pad while Num Lock is on, so they type digits instead of moving. Press Num Lock to switch the pad to navigation, or use the separate arrow keys. Enabling the Num Lock indicator in Excel's status bar makes this easy to spot.
Conclusion
In Excel, arrow keys not working is usually down to Scroll Lock, which you switch off with the ScrLk key or the On-Screen Keyboard. If not, check Edit mode, Num Lock, sheet protection and add-ins in that order. For a fully supported Excel, see our Microsoft Office collection, including Office 2024 Professional Plus.
Useful Links
| Resource | Link |
|---|---|
| Microsoft Office licences | Shop Microsoft Office |
| Office 2024 Professional Plus | Buy Office 2024 Pro Plus |
| Freeze rows in Excel | Freeze the Top Two Rows |
| Fix a damaged workbook | Repair a Corrupted Excel File |
| Turn off Scroll Lock (Microsoft) | Microsoft Support |
Leave a comment