Excel Arrow Keys Not Working? Fix Scroll Lock and More

If the arrow keys move the worksheet instead of the selected cell, turn off Scroll Lock; on many Windows keyboards, press ScrLk once. If they do nothing, first exit cell-edit mode by pressing Enter to keep your edit or Esc to cancel it, then click a worksheet cell and try again. These two checks solve many cases, but the right fix depends on what the keys actually do.

First identify what the arrow keys are doing

Watch the active-cell border and the worksheet while pressing an arrow key. The symptoms help narrow down the cause:

The sheet scrolls, but the selected cell does not change: Scroll Lock is the leading suspect.
The insertion point moves inside a cell or formula: Excel is editing that cell, rather than navigating the grid.
A chart, shape, or other object moves: That object may be selected instead of a cell.
Nothing happens: Excel may not have keyboard focus, a dialog could be waiting for input, or the key or keyboard may have a problem.
The selection changes but seems to stay in one area: frozen panes, merged cells, or sheet-protection settings may make navigation look unusual.

Try the same arrow key in another worksheet, then in a different application such as a text editor. If it fails everywhere, investigate the keyboard or operating system before changing Excel settings. If it fails only in one workbook or sheet, focus on that sheet’s editing state, protection, or layout.

Turn off Scroll Lock in Excel

Scroll Lock changes the arrow keys’ behavior in Excel: instead of moving the active cell, they scroll the worksheet. This is useful in some situations, but it can make navigation feel broken if the key was pressed accidentally. The active-cell outline generally remains in place while the visible grid moves.

On a full-size Windows keyboard, press ScrLk or Scroll Lock once, then test an arrow key. Some laptops omit this key or place it behind an Fn combination. The combination varies by computer manufacturer and model, so check the keyboard markings or the device’s documentation rather than assuming one shortcut applies to every laptop.

If there is no physical key, Windows includes an On-Screen Keyboard. Open it with Windows key + Ctrl + O, then select ScrLk if that key is shown. Test the arrow keys again and close the On-Screen Keyboard when finished. You can also look at Excel’s status bar: when its Scroll Lock indicator is displayed, it can help confirm the state. If you do not see the indicator, that alone does not prove Scroll Lock is off; status-bar items can be hidden.

On a Mac, keyboard layouts differ and many do not have a dedicated Scroll Lock key. Some extended keyboards use Shift+F14, and some laptop keyboards may require Fn as well. If that does not apply to your keyboard, check its documentation and the version of Excel you use. Do not keep pressing random function-key combinations, since they may activate unrelated system or Excel features.

Exit cell-edit mode without losing work

When you type directly into a cell or edit a formula, Excel enters edit mode. In that mode, the arrow keys move the text cursor through the cell’s contents or formula instead of selecting a neighboring cell. You may see a cursor in the cell or formula bar, and the formula bar’s Cancel and Enter controls may be active.

Press Enter to commit the edit, or Esc to cancel the current edit, then try the arrow keys. Be aware that Esc discards the unfinished change; use Enter if you want to keep it. If you are unsure whether Excel is editing a cell, click the formula bar or press F2 only when you intend to enter edit mode. Pressing F2 again can toggle between editing and selecting a cell reference in a formula, depending on the context.

A related case occurs when the formula bar, a dialog box, or another control has keyboard focus. Click an ordinary worksheet cell once and test navigation. If a dialog is open, finish or close it first; Excel may be waiting for a response, so worksheet keys will not behave normally.

Check which part of the workbook has focus

Arrow keys can act on a selected object rather than the worksheet grid. For example, if a chart, picture, or shape is selected, an arrow key may move that object. Press Esc to leave the object selection, or click a cell that is not covered by an object, and try again. If the object covers much of the sheet, use the Name Box to select a cell by address, such as A1, then test the keys.

Also check whether you are working in the expected workbook window or worksheet. A modal dialog, a second workbook, or a different application can receive the keystrokes instead. Clicking a visible cell in the workbook is a quick way to restore Excel’s grid focus. If the workbook is open in a browser, click inside the worksheet grid rather than the browser toolbar or another page control.

Understand frozen panes and unusual worksheet layouts

Frozen panes do not normally disable arrow-key navigation. They keep selected rows or columns visible while other parts of the worksheet scroll. As you move through a large sheet, the active cell can travel beyond the frozen area while headings remain fixed, which may make the movement look different from an unfrozen sheet.

To inspect the setting in Excel for Microsoft 365 on Windows, use View > Freeze Panes. The menu offers options to unfreeze panes or freeze rows and columns. If the layout is confusing, choose Unfreeze Panes temporarily and test navigation. This changes the view, not the cell contents. You can restore the intended frozen layout afterward.

Merged cells can also make movement appear irregular: a merged region occupies more than one row or column, but Excel treats it as a single merged area for selection. When navigating near merged cells, the selection may not advance in the simple one-cell pattern you expect. Test the keys in an unused area of the sheet to see whether the behavior is limited to that layout.

Review worksheet protection and selection settings

Protection can limit which cells you may select. On a protected sheet, the person who protected it can choose whether users may select locked cells, unlocked cells, both, or neither. If neither type is selectable, arrow-key navigation may seem unavailable on that sheet. Other protection settings may allow movement only among permitted cells.

Look at the Review tab for the sheet’s protection controls. If you are authorized to change the sheet, use Review > Unprotect Sheet and provide the password if Excel requests one. Do not try to bypass protection; ask the workbook owner for access or for a version with the appropriate selection permissions. A protected sheet is different from Scroll Lock: protection restricts actions on that worksheet, while Scroll Lock changes how the arrow keys scroll the view.

Separate an Excel problem from a keyboard problem

When the simple checks fail, isolate where the fault occurs. Test the arrow keys in another workbook and another application. If they fail across applications, inspect the keyboard for a stuck or damaged key, reconnect an external keyboard, or try another keyboard. On a laptop, an external keyboard can help determine whether the built-in keyboard is the issue.

If the keys work in other programs but fail in Excel, close any open dialogs, save the workbook, and restart Excel. If the problem persists, you can start Excel in Safe Mode on Windows to check whether an add-in or startup customization is involved: press Windows key + R, enter excel /safe, and press Enter. Test a blank workbook. Safe Mode is a diagnostic step, not a permanent repair; if the keys work there, investigate installed add-ins or customizations. You can review Excel add-ins through File > Options > Add-ins, but disable items only if you know what they are and can restore them.

Do not reset keyboard settings or reinstall Office as a first step. Scroll Lock, edit mode, and focus are quicker to check and are less disruptive. If the issue is limited to one workbook, make a copy before trying repairs, and check whether the workbook contains unusual objects, protection, or a sheet layout that explains the behavior.

Excel for Mac and Excel for the web

Most navigation checks are the same across desktop versions: click a cell, exit edit mode, and observe whether the selection or the worksheet moves. The main difference is keyboard hardware. Mac keyboards may not provide a Scroll Lock key, and the available key combination depends on the keyboard. For an external keyboard or a function-key combination, consult its documentation rather than assuming Windows laptop instructions apply.

In Excel for the web, make sure the worksheet grid has focus; a browser control or another page element can capture keystrokes. If the behavior remains unclear, open the workbook in the Excel desktop app, if available, and compare. That helps distinguish a browser-focus issue from a workbook or keyboard issue. Menu labels and some features can differ between the web and desktop versions, so do not rely on a Windows-only keyboard shortcut working identically in a browser.

Frequently Asked Questions

Why do the arrow keys scroll the page instead of changing cells?
Scroll Lock is probably on. Turn it off with the ScrLk key or, on Windows, the On-Screen Keyboard. If the active cell changes while the sheet moves, check whether you are seeing normal scrolling around frozen panes instead.

How do I turn off Scroll Lock if my keyboard has no ScrLk key?
On Windows, open the On-Screen Keyboard with Windows key + Ctrl + O and click ScrLk if it is available. On a Mac, keyboard support varies; check the keyboard documentation for a Scroll Lock equivalent or supported key combination.

Why do arrow keys move the cursor inside a formula?
The cell is being edited. Press Enter to save the formula edit or Esc to cancel it. Once Excel returns to cell-selection mode, the arrows should move between cells.

Can frozen panes stop arrow keys from working?
They should not disable navigation. Frozen panes keep chosen rows or columns visible while the worksheet scrolls. If that view is confusing, use View > Freeze Panes to unfreeze them temporarily and test again.

Why do arrow keys work in other apps but not in one Excel sheet?
Check whether the sheet is protected and whether selection is restricted, or whether a cell is still being edited. Also test an empty area of the sheet; merged cells and selected objects can make movement look unusual. If the issue affects only one workbook, ask its owner about protection or layout settings.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.