If the arrow keys scroll the worksheet instead of moving the active cell, turn off Scroll Lock: press the ScrLk key on your keyboard, then try an arrow key again. If that does not fix it, check whether Excel is editing a cell, whether the sheet is protected, or whether the keyboard is sending input correctly.
Start with the symptom: scrolling or cell movement?
In Excel for Microsoft 365 on Windows, arrow keys normally move the selected cell one row or column at a time. When Scroll Lock is on, the arrows instead scroll the worksheet while the active cell stays where it was. That is the most common explanation when the keys appear to work but the selection does not move.
Look at the name box, just to the left of the formula bar. It shows the address of the active cell, such as B4. Press an arrow key and compare what happens:
- If the worksheet view moves but the name box still shows the same cell, suspect Scroll Lock.
- If the active-cell address changes, navigation is working; the issue may be that the sheet has moved or the selection is not easy to see.
- If nothing changes, or a cell, shape, or text cursor reacts unexpectedly, check the other causes below.
This distinction matters because arrow keys can behave differently depending on what has focus. A cell, a formula being edited, a chart, and the worksheet grid are not the same input target.
What Scroll Lock does in Excel
Scroll Lock is a keyboard mode that changes how certain navigation keys behave. In Excel, it changes arrow-key navigation from moving the active cell to moving the worksheet viewport. For example, if C5 is selected, pressing the right arrow with Scroll Lock active can shift the visible columns while C5 remains the active cell.
Scroll Lock is a setting on the keyboard, not a worksheet option that you need to change in every workbook. It can be switched on accidentally, especially on a full-size keyboard with a dedicated ScrLk key or on a laptop where the key is combined with another function. Closing and reopening Excel may not clear it because the keyboard mode can remain on.
Excel may show Scroll Lock on its status bar at the bottom of the window. If the indicator is not visible, right-click the status bar and look for the Scroll Lock item in the list of status-bar options. Its presence can confirm the cause; pressing the key or using the On-Screen Keyboard to switch it off should restore normal cell navigation.
Turn off Scroll Lock on a Windows keyboard
First, look for a key labelled ScrLk, Scroll Lock, or a similar abbreviation. Press it once, then test an arrow key in the worksheet. On a desktop keyboard, it may be near Print Screen and Pause. Some keyboards use a light or on-screen indicator to show whether the mode is active, but not all do.
On laptops and compact keyboards, Scroll Lock may be a secondary function rather than a separate key. Try the key combination printed on the keyboard, often involving Fn and a key marked ScrLk. The exact combination varies by manufacturer and model, so check the computer’s keyboard guide rather than assuming one universal shortcut. If the keyboard has an Fn Lock mode, that can also affect which function a key sends.
If there is no usable physical key, use Windows’ On-Screen Keyboard:
- Open Start and go to Settings > Accessibility > Keyboard in Windows 11. In Windows 10, go to Settings > Ease of Access > Keyboard.
- Turn on On-Screen Keyboard. You can also open it with Ctrl+Windows key+O.
- Select ScrLk on the on-screen keyboard if it is shown, then return to Excel and test an arrow key.
The on-screen layout can vary. If ScrLk is not visible, open the keyboard’s Options and check whether enabling the numeric keypad changes the available keys. Once the worksheet selection moves normally, you can close the On-Screen Keyboard.
Check whether Excel is still editing a cell
Excel has a cell-navigation mode and an editing mode. When you are editing a cell, the arrows can move the text cursor within the cell’s contents instead of selecting a neighboring cell. This is expected behavior, not a keyboard fault. It can happen after pressing F2, double-clicking a cell, or typing into the formula bar.
Look for a text insertion point inside the cell or formula bar. Press Esc to cancel the edit, or Enter to accept it, then try an arrow key again. If you want to keep the change, use Enter; Esc abandons the current edit. If the cursor is in the formula bar, click back into the worksheet grid after finishing the edit.
Other keyboard states can change what you see. Holding Shift while pressing an arrow extends the selection rather than moving just the active cell. Ctrl+an arrow can jump to the edge of a contiguous data region. F8 enables Extend Selection, which makes arrow keys expand a selection; press F8 again or Esc to leave that mode. These behaviors can look like a failure if you expect a one-cell move.
Look for a selected object or a protected worksheet
If a chart, picture, text box, or other object is selected, the arrow keys may move or adjust that object instead of changing the active cell. Click an ordinary cell in the grid and test again. A border with sizing handles around a chart or shape is a clue that the object, not a cell, has focus.
Worksheet protection is another possible reason navigation seems restricted. A protected sheet can limit which cells users may select, depending on the permissions chosen when protection was applied. Try clicking a clearly unlocked cell, if one is available. If you need to change the sheet’s permissions, use Review > Unprotect Sheet, if you have authorization and the required password. Do not assume protection can or should be bypassed; ask the workbook owner when the file is managed by someone else.
Frozen panes and hidden rows or columns can make navigation confusing, but they do not normally disable arrow keys. With frozen panes, part of the worksheet stays in place while another part scrolls. The active cell can move through the grid even though the view does not behave like a single continuous page. Check the cell address as well as the visible area before concluding that navigation is blocked.
Determine whether the keyboard or Excel is the problem
Test the arrow keys in another application. In a text editor, they should move the insertion point through text; in a browser, they may scroll a page depending on where focus is. If the keys fail across multiple applications, the issue may be the physical keyboard, a keyboard connection, a laptop function-key setting, or input software rather than Excel.
For a USB keyboard, reconnect it or try another port. For a wireless keyboard, check its power and connection. If available, test another keyboard or use the On-Screen Keyboard. Avoid changing several settings at once: a simple comparison between Excel, another application, and a second keyboard can narrow down the cause.
If the arrows work elsewhere but not in one workbook, test a blank workbook. If they work there, return to the original file and check for editing mode, protection, selected objects, or unusual workbook-specific behavior. If they fail in every Excel workbook but work elsewhere, close Excel and reopen it. You can also check for updates under File > Account > Update Options > Update Now. Menu wording may differ in work or school installations managed by an administrator.
Excel for Mac and Excel for the web
The steps above focus on Excel for Microsoft 365 on Windows. Mac keyboards often lack a dedicated Scroll Lock key. Microsoft’s documented key combination for Excel for Mac is Shift+F14; on some keyboards, Fn+Shift+F14 is needed to send the F14 key. Keyboard layouts differ, so if that combination is unavailable, consult the keyboard or Mac documentation. Windows’ On-Screen Keyboard steps do not apply to macOS.
In Excel for the web, first click a worksheet cell so the grid has focus. A browser can use arrow keys to scroll the page or move focus among controls when the worksheet is not active. If you are using an external keyboard, check whether it has a Scroll Lock key and test the workbook in the desktop app if available. This helps distinguish browser focus from Excel’s cell-navigation behavior.
Across versions, the basic diagnostic still applies: watch the active-cell address. If the view scrolls but the address does not change, investigate Scroll Lock; if the address changes, the arrows are navigating even if the worksheet layout makes that movement less obvious.
How to avoid the problem returning
Once cell navigation works, note what turned Scroll Lock on. On a shared desktop or laptop, a key combination may have been pressed inadvertently. If you use a compact keyboard, learn the model-specific Fn combination or keep the On-Screen Keyboard route handy. When a workbook is shared, avoid changing protection settings just to solve an arrow-key issue unless you are responsible for the file.
It is also useful to recognize Excel’s normal navigation shortcuts. Shift+arrow extends a selection, Ctrl+arrow jumps to a data-region boundary, and F8 extends selection until toggled off. These are useful tools, but if they are triggered unintentionally they can make a working keyboard appear broken. Press Esc, release modifier keys, and click a cell to return to a clear starting point before testing.
Frequently Asked Questions
Why do my arrow keys scroll the sheet instead of changing cells?
Scroll Lock is usually on. Turn it off with the ScrLk key or Windows On-Screen Keyboard, then check that the active-cell address changes when you press an arrow.
How do I turn off Scroll Lock if my keyboard has no ScrLk key?
In Windows, open Settings > Accessibility > Keyboard and turn on On-Screen Keyboard, then select ScrLk if it is available. The keyboard shortcut Ctrl+Windows key+O also opens it.
Why do arrow keys move the cursor inside a cell?
The cell or formula bar is in edit mode. Press Enter to accept the edit or Esc to cancel it, then select a cell in the worksheet grid.
Why do the arrow keys move a chart instead of selecting cells?
The chart or another object may be selected. Click a worksheet cell outside the object, then try the arrows again.
Do frozen panes stop arrow-key navigation?
No. Frozen panes keep selected rows or columns visible while the rest of the sheet scrolls. Check the active-cell address to confirm whether the selection is moving.
Related
- How to Move Down a Line in Excel: Cells, Rows, and Text
- How to Move Freeze Panes in Excel to Different Rows
- How to Move Everything Down a Row in Excel Safely
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Google Sheets Apps Script Not Working? Fixes to TryIf Apps Script is not working in Google Sheets, first check whether the script is attached to the…
- Excel Cell Drag Not Working? Fix the Fill HandleIf Excel cell dragging is not working, first check whether the fill handle is enabled: in Windows Excel,…
- VLOOKUP Not Working? Fix Common Excel Lookup ErrorsIf VLOOKUP is not working in Excel, first set its final argument to FALSE for an exact match,…
- Transpose Not Working in Excel? Common Causes and FixesIf Transpose is not working in Excel, first check that you copied a cell range, then paste it…
- Excel Print Area: How to Fix It and Print the Right CellsTo fix an Excel print area, select the cells you want on paper, then choose Page Layout >…
- Excel A4 Print Area: Set It Up and Fix Printing ProblemsTo print an Excel worksheet on A4 paper, choose Page Layout > Size > A4, select the cells…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.