If the arrow keys scroll the worksheet instead of selecting a different cell, turn off Scroll Lock; in Excel for Microsoft 365 on Windows, press the Scroll Lock key, or use the Windows On-Screen Keyboard if your keyboard has no such key. If the keys do nothing or move within text, first exit cell-edit mode and click a worksheet cell. These checks resolve the most common reasons Excel’s arrow keys seem not to change cells.
What normal arrow-key behavior looks like
When a worksheet cell is selected and Excel is not editing its contents, pressing an arrow key moves the active-cell selection one cell in that direction. For example, if B3 is selected, the Right Arrow normally selects C3. Excel may also scroll the visible worksheet when the active cell approaches the edge of the window, but the selected cell still changes.
Arrow keys are navigation keys, not commands to change a cell’s value. If you expect the displayed number or text to change, you need to enter or edit data, use a formula, or run an action that changes the contents. Keeping that distinction in mind helps separate a navigation problem from a data-entry or calculation problem.
Turn off Scroll Lock
Scroll Lock is the leading cause when the arrow keys visibly move the sheet but the selected cell stays in place. It changes the effect of the arrows: Excel scrolls the worksheet view rather than moving the active-cell selection. This is a keyboard state, not a setting in the cell or workbook, so it can be switched on accidentally.
- Look at Excel’s status bar at the bottom of the window for a Scroll Lock indicator. If it is not visible, right-click the status bar and check whether Scroll Lock is enabled in its list of status-bar items. The indicator may be hidden even when Scroll Lock is on.
- Press the Scroll Lock key, sometimes labelled ScrLk or ScrLk/ScrLk, once, then try an arrow key again. The exact label and key combination depend on the keyboard.
- If your keyboard has no Scroll Lock key, open the Windows On-Screen Keyboard: press the Windows key, type On-Screen Keyboard, and open the matching Windows app. Select ScrLk on the on-screen keyboard to switch the state off.
Some compact and laptop keyboards put Scroll Lock behind an Fn combination. Check the keyboard’s key labels or its manufacturer’s instructions rather than assuming one Fn shortcut applies to every model. The On-Screen Keyboard is a useful alternative when the key is missing or its combination is unclear.
Exit cell-edit mode
If an arrow key moves a cursor through letters or numbers inside a cell, Excel is editing the cell rather than navigating the sheet. This can happen after you start typing, press F2, or double-click a cell. While editing, arrows can move the insertion point through the cell’s text; if you are editing a formula, an arrow can also insert a reference to another cell.
Press Enter to commit the edit, or press Esc to cancel it, and then press an arrow key. If you are unsure whether Excel is editing, look at the formula bar and the cell: a text cursor or an insertion point in the formula is a clue. You can also click another cell after deciding whether the current edit should be kept. Avoid pressing Esc if you need to preserve a change that has not yet been committed.
A related source of confusion is selecting a cell and immediately typing. Excel treats the typing as new cell content, not as a command to navigate. To move without replacing anything, finish the entry with Enter or cancel it with Esc before using the arrows.
Check selection modes and navigation keys
Some keyboard modes alter what arrows do without indicating that Excel is broken. Pressing F8 turns on Extend Selection mode, in which navigation can extend a selection instead of simply replacing it with one active cell. Press F8 again to leave that mode. If the status bar shows Extend Selection or EXT, that is a useful clue. On a laptop, you may need to use Fn with F8 if the function keys are assigned to hardware controls.
Also check whether you are using a navigation shortcut rather than a plain arrow. In Windows desktop Excel, Ctrl+an arrow key jumps to the edge of a populated region or to the edge of the worksheet when there is no adjacent data in that direction. It is expected to skip many cells. Pressing just the arrow key returns to one-cell-at-a-time movement. Mac keyboard shortcuts differ; in Excel for Mac, Option+an arrow generally navigates to the edge of a data region, while Command+an arrow can move to the edge of the worksheet.
Frozen panes can make the view look unusual because some rows or columns remain visible while another area moves. They do not normally prevent the active cell from changing. Likewise, a protected sheet can restrict which cells are selectable, depending on its protection settings. If navigation works in some cells but skips or stops at particular locked areas, the sheet’s protection and selection permissions may explain the behavior.
Check keyboard, focus, and workbook conditions
Excel only receives a key press when it has keyboard focus. Click a worksheet cell once, then test the arrows. If focus is in the formula bar, a search box, a dialog, a chart, or another control, the keys may act on that control instead of moving the active cell. Close an open dialog with its appropriate button or return to the grid before testing again.
If clicking the grid does not help, test the arrow keys in another workbook or a blank worksheet. If they work there, the issue is more likely tied to the current workbook, worksheet protection, an editing state, or a particular selected object. If they fail in other applications too, inspect the keyboard, its connection, and any keyboard utility or remapping software. A faulty or remapped key can imitate an Excel problem.
When the issue affects only one workbook, save your work and reopen the file. You can also compare behavior in a new blank workbook. If the problem remains limited to one sheet, check whether the sheet is protected and whether the active selection is a chart or other object rather than a cell. These comparisons help locate the cause without changing workbook data unnecessarily.
Excel for Mac and Excel for the web
On a Mac, the first checks are similar: click a worksheet cell, make sure you are not editing its contents, and test the arrows. Many Mac keyboards do not have a dedicated Scroll Lock key, so do not assume that a Windows ScrLk instruction maps to a standard Mac key. Keyboard layouts and external keyboards vary; consult the keyboard’s documentation if it includes a Scroll Lock function. Also account for the Mac navigation shortcuts described above when diagnosing jumps across data.
In Excel for the web, make sure the workbook grid has focus. A browser address bar, dialog, or another page control can receive the keystrokes instead. Click a cell and test again. Browser-based Excel and desktop Excel do not expose every keyboard feature in exactly the same way, so a missing desktop status-bar indicator or a different keyboard layout is not by itself proof that the workbook is damaged. If the same file behaves differently in desktop Excel, compare the two environments before changing its contents.
A quick troubleshooting order
For the fastest diagnosis, try the checks in this order and stop when navigation returns to normal:
- Click an ordinary worksheet cell to return focus to the grid.
- Press Enter to finish an edit or Esc to cancel an unwanted edit.
- Turn off Scroll Lock using the keyboard or Windows On-Screen Keyboard.
- Press F8 once if Extend Selection mode appears to be active.
- Use a plain arrow key rather than Ctrl+arrow or another navigation shortcut.
- Test another sheet or workbook; if the problem persists, test the keyboard outside Excel.
This order starts with reversible, low-risk checks. It avoids resetting Excel or changing workbook settings before you know whether a keyboard mode or focus issue is responsible. If the keys move the visible page but not the selection, prioritize Scroll Lock. If they move through text, prioritize edit mode. If they jump a long way, check whether a modifier key is being held.
Frequently Asked Questions
Why do arrow keys scroll the sheet instead of changing the selected cell?
Scroll Lock is probably enabled. Turn it off with the Scroll Lock key, or use the Windows On-Screen Keyboard to select ScrLk if your keyboard does not have that key. Then click a cell and test an arrow.
How do I turn off Scroll Lock if my laptop has no ScrLk key?
In Windows, open the On-Screen Keyboard by searching for it from the Start menu or Windows key, then select ScrLk. Some laptop keyboards also provide an Fn combination, but the combination varies by model.
Why do the arrow keys move the cursor inside a cell?
The cell is being edited. Press Enter to keep the edit or Esc to cancel it, then use the arrows to navigate. While editing a formula, arrows may select a cell reference rather than move the worksheet selection.
Why does Ctrl+Arrow skip cells in Excel?
In Windows desktop Excel, Ctrl+an arrow moves to the edge of a populated region or worksheet boundary, so it is designed to jump rather than move one cell. Use the arrow key without Ctrl for normal one-cell movement.
Do arrow keys change cell values?
No. They move the active selection when Excel is in normal navigation mode. To change a value, enter or edit the cell’s contents; to change a displayed result, the cell may contain a formula whose inputs need to change.
Related
- Excel Data Analysis Skills: What They Include and Why
- Excel Solver for Data Analysis: Setup, Models, and Limits
- Cash Flow Excel Sheet: Build a Reliable Monthly Forecast
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Insert Row After Change in Data AutomaticallyTo insert a row after each change in a sorted Excel list, use a short VBA macro to…
- Insert a Personal Signature in Word for Mac: Steps & TipsTo insert a personal signature in Word for Mac, save a picture of your handwritten signature, then choose…
- How to Share an Outlook Calendar ExternallyYes. You can share an Outlook calendar with someone outside your organization by opening the calendar’s sharing controls,…
- Excel Goal Seek Precision: Accuracy and LimitsExcel Goal Seek can find an input value that makes a formula reach a target, but it does…
- Google Sheets Apps Script Page Not Found? Causes and FixesIf Google Sheets Apps Script says “page not found,” first check that you opened the script editor from…
- Google Sheets Filter Views: Create, Use, and Share ThemA Google Sheets filter view is a saved way to sort or filter a table without changing the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.