If an Excel cell will not move when you press an arrow key, first check whether Scroll Lock is on; it makes the worksheet scroll while the selected cell stays put. If the arrow keys move a cursor inside the cell instead, press Enter or Esc to leave edit mode, then try again. These two situations explain many apparent navigation problems, but a few selection and worksheet settings can also change what you see.
What the arrow keys normally do in Excel
In Microsoft Excel for Microsoft 365 on Windows, an arrow key normally moves the active-cell selection one cell in that direction. The active cell is the cell outlined on the worksheet, and its address appears in the Name Box to the left of the formula bar. When the selection reaches the edge of the visible window, Excel usually scrolls the sheet to keep the active cell in view.
It helps to distinguish movement of the selection from movement of the worksheet. Watch the Name Box while pressing an arrow key:
- If the address changes, Excel is moving the active cell.
- If the sheet shifts but the address stays the same, the worksheet is scrolling instead.
- If the selection stays put and a text cursor appears in the cell or formula bar, Excel is in an editing state.
Those clues help identify the cause before changing settings. A frozen-looking screen is not always a frozen worksheet: Excel may be following a different navigation rule, or the active cell may have moved outside the visible area.
Turn off Scroll Lock
Scroll Lock is the first setting to check when the worksheet moves under a selection that does not change. With Scroll Lock enabled, the arrow keys scroll the worksheet rather than moving the active cell. This behavior can make it seem as if Excel has stopped responding, even though the keys are working as configured.
On a Windows keyboard with a Scroll Lock key, press Scroll Lock or ScrLk once, then test an arrow key. Some keyboards use a function-layer combination, often involving Fn, and the exact combination depends on the keyboard manufacturer. If there is no physical key, Windows offers an On-Screen Keyboard:
- Open Start, search for
On-Screen Keyboard, and launch it. - Look for the
ScrLkkey. If it is not visible, check the keyboard options for the navigation-key layout. - Select
ScrLkto switch the state, then return to Excel and test the arrows.
Excel may show Scroll Lock in its status bar when the feature is active. If you do not see it, right-click the status bar and check whether Scroll Lock is available as a status indicator; available indicators can vary by Excel version. The indicator is useful, but the unchanged cell address while the sheet scrolls is also a strong clue.
Leave cell-editing mode
If an arrow key moves through text inside a cell instead of selecting a neighboring cell, Excel is editing the cell’s contents. This can happen after you double-click a cell, start typing, press F2, or click in the formula bar. While editing, the arrows position the insertion point in the text or formula. That is expected behavior, not a keyboard fault.
Press Enter to accept the edit and move out of the cell, or press Esc to cancel the current edit. Then press an arrow key again. If you want to keep editing but move the text cursor, click in the cell or formula bar and use the arrows there. Be careful with Esc: it cancels the current uncommitted edit, so use Enter if you need to keep the changes.
Formula entry can cause a related surprise. While typing a formula, an arrow key may insert a reference to the cell in that direction instead of moving the selection normally. For example, while entering a formula in a cell, pressing the left arrow can add a reference to the cell on the left. Finish or cancel the formula before testing ordinary navigation.
Check selection modes and navigation shortcuts
Some keyboard modes alter the selection without preventing movement. If F8 was pressed, Extend Selection mode may be on: the active selection expands as you move with the arrows. Excel displays Extend Selection in the status bar. Press F8 again to turn the mode off. On a laptop, you may need Fn+F8 if the function keys control hardware features by default.
Shift+F8 turns on Add to Selection mode, which lets you add another range to a selection. Press Esc to stop adding ranges. These modes can make the highlight look unexpected, but the active cell can still move.
Other shortcuts change how far or where Excel moves:
- An arrow key alone usually moves one cell.
Ctrlplus an arrow key on Windows jumps to the edge of a data region or to the next nonblank boundary, depending on the surrounding cells.Shiftplus an arrow key extends the selection rather than moving a single-cell highlight.Ctrl+Homemoves to the beginning of the worksheet, usually cell A1;Ctrl+Endmoves to the last used cell.
These shortcuts are useful for navigation, but they are not fixes for a nonmoving cell. If an unexpected shortcut seems to be active, press Esc, check the status bar for a selection mode, and test a plain arrow key without holding another key.
Consider frozen panes, merged cells, and protection
Frozen panes keep designated rows or columns visible while you scroll. They do not normally prevent the active cell from moving. However, the fixed area can make it look as though only part of the worksheet is moving. To inspect the setting in Excel for Windows, open View > Freeze Panes. The menu offers options to unfreeze panes or change which rows and columns remain visible. Use Unfreeze Panes if you want to test the sheet without a frozen region.
Merged cells can make arrow-key navigation feel irregular. A merged range acts as one larger cell, so the selection may move past an area in a way that does not match a simple one-column step. Check whether the selected cell is part of a merged range using Home > Merge & Center. Avoid unmerging cells casually in a shared or formatted workbook, because doing so changes its layout.
Worksheet protection can also restrict which cells you can select or edit. A protected sheet may allow selection only of unlocked cells, depending on the protection options chosen by the workbook’s creator. Look for a protection notice or a disabled command, and check Review > Unprotect Sheet if you are authorized and have the required password. Protection is not the same as Scroll Lock: it generally limits actions on the sheet rather than making every arrow key scroll the window.
Use a quick troubleshooting sequence
When the cause is unclear, use a short sequence that changes as little as possible. This avoids disrupting workbook settings while narrowing down the problem:
- Click an ordinary, unmerged cell that is not being edited.
- Press
Esconce, then pressEnterif you were typing in the cell and want to commit the entry. - Press a single arrow key and watch both the selection border and the Name Box.
- If the sheet scrolls but the address does not change, switch off Scroll Lock and try again.
- If the highlight expands, check for Extend Selection or Add to Selection mode and press
F8orEscas appropriate. - Try the same key in another workbook. If it works there, inspect the original sheet for protection, merged cells, or frozen panes.
- If the key fails in other applications too, check the keyboard, function-key layer, connection, or input settings rather than changing the workbook.
For a broader Excel check, save your work, close and reopen the workbook, and test a blank workbook. If the problem occurs in every workbook but not other programs, close Excel and reopen it before considering more involved troubleshooting. Avoid changing several settings at once: doing so makes it harder to tell which change fixed the issue.
Windows, Mac, and Excel for the web differences
The instructions above primarily describe Excel for Microsoft 365 on Windows. On Windows, the physical Scroll Lock key or the On-Screen Keyboard provides a direct way to change Scroll Lock. Some compact keyboards hide the key behind an Fn combination, so consult the keyboard’s own layout rather than assuming one universal shortcut.
Mac keyboards do not all include a dedicated Scroll Lock key, and function-key behavior varies with the keyboard and macOS settings. If you use Excel for Mac and see the sheet scroll without the active cell changing, check for a Scroll Lock indicator in Excel and consult the instructions for your specific keyboard. Do not assume a Windows Fn combination will apply to a Mac. The general checks still help on Mac: leave cell-editing mode, test a plain arrow key, and compare the active-cell address with the visible movement.
Excel for the web runs in a browser, where keyboard input can also be affected by browser focus. Click a worksheet cell before testing the arrows; if focus is in the address bar, a search field, or another browser control, the keys may act there instead of in the grid. The browser version’s available controls differ from the Windows desktop app, so a missing desktop status-bar indicator does not by itself prove that Scroll Lock is off.
Frequently Asked Questions
Why do arrow keys scroll the sheet instead of moving the selected cell?
Scroll Lock is the most likely cause. Turn it off with the keyboard’s Scroll Lock key or, on Windows, the On-Screen Keyboard. Confirm the result by checking whether the active-cell address changes when you press an arrow key.
Why do arrow keys move the cursor inside a cell?
The cell or formula bar is in edit mode. Press Enter to keep the edit and leave the cell, or Esc to cancel it. Then use the arrow keys to navigate between cells.
Why does the selection move several cells at once?
You may be holding Ctrl, which changes arrow-key navigation to jump across a data region or boundary on Windows. Release Ctrl and test a plain arrow key. Also check whether the destination is part of a merged range.
Can frozen panes stop arrow-key movement?
Frozen panes normally keep rows or columns visible; they do not stop the active cell moving. They can make scrolling look unusual. Check View > Freeze Panes and temporarily choose Unfreeze Panes if you need to compare behavior.
What if arrow keys do not work in any Excel workbook?
Check whether Excel is in edit mode or Scroll Lock is on, then test the keyboard in another application. If keys fail only in Excel, restart the app and test a blank workbook; if they fail elsewhere too, inspect the keyboard or its connection.
Related
- Power Query Remove Leading Zeros Without Losing IDs
- Power Query Reference: What It Does and When to Use It
- Excel Data Validation: Can You Select Multiple Items?
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Outlook 2013 Rules to Run a Script: Setup and SafetyYes. In classic Outlook 2013 for Windows, you can create a rule that runs a VBA procedure: add…
- Find and Replace Alt+Enter in Excel: Remove Line BreaksTo find and replace an Alt+Enter line break in Excel for Microsoft 365 on Windows, press Ctrl+H, click…
- How to Set Up Auto Forward in Outlook for MacTo automatically forward every new message from Outlook for Mac, open your mailbox in Outlook on the web,…
- Google Sheets Conditional Formatting If True: How It WorksYes. In Google Sheets, conditional formatting applies a style when a cell meets a selected condition; for more…
- How to Delete a Page in Word for the Web Without ErrorsTo delete a page in Word for the web, select the text or other content on that page…
- Create a Cursive Signature in Outlook: Step-by-StepTo create a cursive signature in Outlook, add either script-style text or a picture of your handwritten signature…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.