Excel Not Moving From Cell to Cell? Fixes That Work

If Excel is not moving from cell to cell when you press the arrow keys, turn off Scroll Lock first: it makes the arrows scroll the worksheet while leaving the selected cell in place. If that is not the cause, exit cell-editing mode and check Excel’s selection and Enter-key settings.

Check what is actually staying still

Watch both the highlighted cell and the worksheet grid as you press an arrow key. When Scroll Lock is on, the visible rows or columns move, but the active-cell outline remains on the same cell. When the outline moves to a neighboring cell, navigation is working; the issue may instead be that Excel is not moving in the direction or manner you expect.

This distinction helps separate a keyboard problem from a display or workbook setting. For example, if the active cell changes from B4 to B5 but the top rows remain visible, frozen panes may be keeping those rows in view. If neither the cell outline nor the grid changes, Excel may be editing a cell, a dialog may have keyboard focus, or the key may not be reaching Excel.

Try clicking an ordinary cell in the worksheet once, then press an arrow key. If the active-cell border moves, Excel itself is responding and the previous focus was elsewhere, such as the formula bar, a search box, or a dialog. If the sheet scrolls without moving the border, investigate Scroll Lock.

Turn off Scroll Lock in Excel for Windows

On a full-size keyboard, press the Scroll Lock or ScrLk key once, then test the arrow keys again. With Scroll Lock disabled, an arrow key should normally move the active selection by one cell. You can often confirm the state by looking for “Scroll Lock” on Excel’s status bar. If the indicator is not visible, right-click the status bar and look for the Scroll Lock item in its list of indicators.

Many laptop keyboards do not have a dedicated Scroll Lock key. The key combination depends on the manufacturer and model; it may involve Fn and a key with a small ScrLk label. Check the keyboard’s labels or the computer manufacturer’s documentation rather than assuming one combination works on every laptop.

Windows includes an On-Screen Keyboard that can help when the physical key is missing:

Open the Start menu and search for On-Screen Keyboard.
Open the keyboard and look for the ScrLk key. If necessary, use the keyboard’s Options button to show the numeric keypad.
Click ScrLk once, return to Excel, and test an arrow key.

If the Scroll Lock indicator disappears and the cell outline starts moving, the problem is resolved. The change affects keyboard navigation, not the cell contents, formulas, or workbook data.

Exit cell-editing mode

Arrow keys behave differently while you are editing a cell. Excel enters edit mode when you type into a selected cell, press F2, double-click a cell, or place the insertion point in the formula bar. In that mode, the arrows can move the text cursor within the cell’s contents or help edit a formula; they do not act like ordinary worksheet navigation.

Look at the status bar for an indication that Excel is in Edit mode, or check whether a text cursor is visible in the cell or formula bar. To finish an edit and keep the change, press Enter. To leave the current edit without keeping the unfinished change, press Esc. Then press an arrow key to move between cells.

This commonly happens when a user presses an arrow after beginning to type a value. For instance, after typing North into a cell, pressing the left arrow may move the insertion point rather than select the cell to the left. Commit the value with Enter first, or cancel the edit with Esc if it was accidental.

Check what Enter is set to do

If the problem happens after you type a value and press Enter, the setting for moving the selection after data entry may be turned off. This is separate from arrow-key navigation: it controls whether Excel selects another cell after you commit an entry. When the setting is off, Excel can leave the selection on the cell you just edited.

In Excel for Microsoft 365 on Windows, open File > Options > Advanced. Under Editing options, check After pressing Enter, move selection. When it is selected, use the Direction list beside it to choose whether Enter moves down, up, left, or right. The default direction is typically down, but a workbook user can change it.

In Excel for Mac, look under Excel > Settings (called Preferences in some earlier releases) and open Edit. Find the option for moving the selection after pressing Return and choose the desired direction. The wording and layout can vary slightly by release. Turning this option on will not change the behavior of arrow keys while a cell is being edited.

Look for other keyboard and selection modes

Some keyboard states can make navigation look unusual even though Scroll Lock is off. If the status bar shows Extend Selection, Excel may be extending a highlighted range as you move. Press F8 to turn off Extend Selection, or press Esc to leave the selection operation. On some laptops, you may need to hold Fn to use the function key.

Also check that the worksheet, rather than another part of Excel, has keyboard focus. Click a cell in the grid and try again. A Find box, open menu, pop-up window, or formula bar can receive keystrokes instead. In Excel for the web, a browser control or dialog may also have focus; click a worksheet cell before retesting.

Use a mouse to click a different cell as a simple diagnostic. If the mouse can select cells but the keyboard cannot, focus, keyboard mode, or the keyboard itself is more likely than a restriction on the worksheet. If neither method selects another cell, check whether the sheet is protected. A protected sheet can limit which cells users may select, depending on the permissions chosen when protection was applied. Review Review > Protect Sheet to see whether protection is active; do not remove protection unless you have permission and understand the workbook’s requirements.

Understand frozen panes and merged cells

Frozen panes can make it seem as if the worksheet is not moving even when the active cell is. Excel keeps designated rows or columns visible while the rest of the sheet scrolls. Look at the cell address in the Name Box, to the left of the formula bar, or watch the selection border closely. If the address changes as you press an arrow key, navigation is occurring.

To change or remove a freeze, use View > Freeze Panes. The available command depends on the current state: Excel may offer options to freeze rows or columns, or to unfreeze panes. Changing this view setting does not alter cell values, but it can change which headings remain visible while you navigate.

Merged cells can also make movement appear to skip cells. A merged area acts as one larger cell for selection, so moving through a sheet with merged regions may not produce the neat one-cell-at-a-time pattern you see in a plain grid. If only some parts of a worksheet behave oddly, inspect the affected area for merged cells before changing keyboard settings.

Use other navigation methods to test the sheet

If you need to get to a particular cell while diagnosing the arrows, use the Name Box. Type a reference such as G25 and press Enter; Excel selects that cell if it is available on the active worksheet. You can also press Ctrl+G on Windows to open the Go To dialog, enter a cell reference, and confirm. These methods help distinguish a navigation-key issue from a problem selecting cells generally.

Other keys have different navigation purposes. Tab typically moves to the next cell on the right, while Enter follows the direction configured in Excel’s editing options. Ctrl+Home on Windows moves to the beginning of the worksheet, usually cell A1. Ctrl plus an arrow key moves to the edge of a contiguous data region or to the next relevant boundary, so it may jump much farther than one cell. These are alternatives, not fixes for Scroll Lock.

A practical troubleshooting order

Work through these checks in order, testing the arrows after each change. This avoids changing unrelated workbook settings when one keyboard state is responsible.

Click a normal worksheet cell and press an arrow. Notice whether the cell border moves, the sheet scrolls, or nothing happens.
If the sheet scrolls but the cell stays put, turn off Scroll Lock using the physical key or the Windows On-Screen Keyboard.
If a text cursor is active, commit the entry with Enter or cancel it with Esc, then try the arrow keys.
If the issue follows data entry rather than arrow presses, check the “After pressing Enter, move selection” option and its direction.
If selection expands, turn off Extend Selection with F8 or Esc. If only certain worksheet areas are affected, check for protection or merged cells.
If keyboard selection still fails, test the keyboard in another application and try another keyboard if available. This can identify a hardware or system-level input problem.

When the problem occurs in only one workbook, compare its sheets and protection settings with a new blank workbook. When it occurs in every workbook, focus first on Scroll Lock, Excel’s editing state, keyboard focus, and the keyboard itself. Avoid changing formulas or deleting data to solve a navigation problem; those actions do not address the usual causes.

Frequently Asked Questions

Why do the arrow keys scroll the sheet instead of changing cells?
Scroll Lock is the most common reason. Turn it off with the Scroll Lock key, a laptop-specific key combination, or the Windows On-Screen Keyboard. Confirm that the active-cell border moves afterward.

Why does Excel stay in the same cell after I press Enter?
The “After pressing Enter, move selection” option may be off. On Windows, find it under File > Options > Advanced > Editing options. Excel for Mac has a similar control under Excel > Settings or Preferences > Edit.

Why do arrow keys move the cursor inside a cell?
The cell or formula bar is probably in edit mode. Press Enter to finish the edit or Esc to cancel it, then use the arrows to navigate between cells.

How do I turn off Scroll Lock if my keyboard has no ScrLk key?
On Windows, search Start for On-Screen Keyboard and click its ScrLk key. Laptop key combinations vary, so check the keyboard labels or the computer maker’s instructions. Mac keyboards do not all provide the same Scroll Lock key or shortcut.

Can frozen panes stop Excel from moving between cells?
Usually, no. Frozen panes keep selected rows or columns visible while you navigate the rest of the sheet. Check the Name Box or active-cell border to see whether the selection is changing; use View > Freeze Panes if you want to change the frozen area.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.