If the arrow keys scroll the worksheet instead of moving the selected cell, Scroll Lock is usually on. Turn it off with the ScrLk key, or open Windows On-Screen Keyboard and click ScrLk; the arrow keys should then move the active cell again.
Why Excel scrolls instead of changing cells
Scroll Lock is a keyboard mode that changes what the arrow keys do in Excel. When it is off, an arrow key moves the active-cell selection one cell at a time. When it is on, the active cell stays where it is while the visible worksheet moves in the direction of the arrow. That can make it seem as if Excel has stopped responding, even though the key presses are being received.
For example, suppose C8 is selected. With Scroll Lock off, pressing the Down Arrow selects C9. With Scroll Lock on, C8 remains selected, but the rows visible in the worksheet shift upward so that you see cells farther down the sheet. The exact amount of scrolling depends on the current view and the key pressed.
This behavior is easy to confuse with normal scrolling, but the key clue is the selection outline: if it stays on the same cell while the worksheet moves, check Scroll Lock first. If the outline moves to another cell, Excel is navigating normally, even if the screen also shifts to keep that cell visible.
Turn off Scroll Lock in Windows
On a full-size keyboard, press the key labeled ScrLk, Scroll Lock, or a similar abbreviation once. It is often near Pause/Break or the navigation keys, though the layout varies. Return to the worksheet and press an arrow key to check whether the selection moves.
If your keyboard has no Scroll Lock key, Windows includes an On-Screen Keyboard with a ScrLk button:
- Open the Windows Start menu and search for On-Screen Keyboard, then launch it.
- Look for ScrLk on the on-screen keyboard. If it appears active or highlighted, click it once to turn Scroll Lock off.
- Click a worksheet cell and test an arrow key. Close the on-screen keyboard when you are finished.
In Windows 11, you can also open Settings > Accessibility > Keyboard and switch on On-Screen Keyboard. In Windows 10, the corresponding path is Settings > Ease of Access > Keyboard, then turn on Use the On-Screen Keyboard. You can use the Start-menu search instead of navigating through Settings in either version.
Excel may show Scroll Lock in its status bar while the mode is active. If you do not see that indicator, right-click the status bar and check whether Scroll Lock is available to display in the status-bar options. The indicator is a useful clue, but not every Excel window or configuration makes it visible by default.
Using a laptop or compact keyboard
Many laptops and compact keyboards omit a dedicated Scroll Lock key to save space. Some provide it as a secondary function, accessed with Fn and another key. The key combination is not universal: it depends on the keyboard maker and model, and the relevant marking may be printed in a smaller color on a key. Check the computer or keyboard manual rather than assuming a combination used by another laptop will work.
If you cannot identify the shortcut, the Windows On-Screen Keyboard is a straightforward alternative and does not require changing Excel settings. After switching Scroll Lock off, you can close it; the mode remains off until it is turned on again. If the ScrLk button is not visible in the on-screen keyboard, check its available keyboard layout or use your device maker’s instructions for its specific keyboard.
When worksheet scrolling is normal
Excel does scroll the sheet during ordinary cell navigation when the active cell reaches the edge of the visible area. For instance, if the bottom visible row is 30 and you keep pressing the Down Arrow, Excel moves the selection to row 31 and scrolls the view enough to show it. In that situation the selection is changing; scrolling simply keeps the newly selected cell in view.
Frozen panes can also make movement look unusual. If rows or columns are frozen, those areas stay in place while the rest of the worksheet moves. This is intentional and does not mean Scroll Lock is on. Look at the selected cell reference, such as C31 in the Name Box to the left of the formula bar, or watch the selection outline to tell whether the active cell is changing.
Similarly, a large worksheet may appear to jump when you navigate quickly, especially if you hold an arrow key down. Try pressing an arrow once and watching the cell border rather than judging only by the movement of the grid.
Other reasons arrow keys may not move cells
Scroll Lock is the most common explanation for a sheet that moves while the selection remains stationary, but a few other situations can affect arrow-key behavior:
- You are editing a cell. After pressing F2 or double-clicking a cell, arrow keys can move the text insertion point within the cell’s contents instead of selecting a neighboring cell. Press Enter to accept the edit or Esc to cancel it, then try the arrows again.
- The worksheet grid does not have focus. If a dialog, formula bar, chart, or another control is active, the keys may act on that control. Click an ordinary worksheet cell before testing navigation.
- You are working in a chart or drawing object. Arrow keys can interact with a selected object rather than move the cell selection. Press Esc or click a cell outside the object.
- You are in Excel for the web and focus has shifted. Click a cell in the grid before using the arrows. If the browser page scrolls, Excel may not have the grid’s keyboard focus.
Worksheet protection can restrict editing, but it does not ordinarily turn arrow keys into Scroll Lock. If a cell cannot be changed, distinguish that problem from navigation: check whether the selection moves and whether Excel displays a protection or editing message.
Excel for Mac and Excel for the web
The primary instructions above are for Excel for Microsoft 365 on Windows. On a Mac, keyboard layouts often do not include a dedicated Scroll Lock key. Some keyboards that provide an F14 key can toggle Scroll Lock with Shift+F14; on keyboards where function keys have alternate controls, you may also need Fn. Key availability and behavior depend on the Mac keyboard, so use the keyboard documentation if that shortcut is unavailable.
In Excel for the web, first click a worksheet cell to ensure the grid has focus. If the browser page moves rather than the selection, the browser may be receiving the arrow keys. Scroll Lock can also affect keyboard navigation depending on the keyboard and environment. A Windows user without a physical key can use the operating system’s On-Screen Keyboard as described above. The browser version does not have the same Windows desktop ribbon and status-bar experience, so desktop menu directions may not match its interface.
How to confirm the problem is fixed
After turning Scroll Lock off, click a cell well inside the visible worksheet and press each arrow key once. The active-cell border should move one cell in the matching direction. If you started at C8, for example, pressing Down should select C9; pressing Right should select D9. If the border moves and the sheet later scrolls as you reach its edge, that is expected behavior.
If the active cell is now off-screen, Excel can bring it back into view with Ctrl+Backspace on Windows. This is a visibility shortcut, not a Scroll Lock toggle. It is useful when you have navigated elsewhere with the mouse or scrolled the worksheet and want to locate the active cell again.
Once navigation works, no workbook repair or cell-format change is needed. Scroll Lock is a keyboard state, not a property of the selected cell or the workbook’s data. If the issue returns, check the keyboard state again; a key press or keyboard shortcut may have turned it back on.
Frequently Asked Questions
How do I know if Scroll Lock is on in Excel?
If the worksheet moves with the arrow keys while the same cell stays selected, Scroll Lock is a likely cause. Excel may also show Scroll Lock on the status bar; if that indicator is not displayed, use the arrow-key test or check the ScrLk key state with the On-Screen Keyboard.
What if my keyboard does not have a Scroll Lock key?
On Windows, search Start for On-Screen Keyboard and click its ScrLk button to switch the mode off. Laptop Fn combinations vary by model, so consult the computer maker’s instructions if you prefer a physical-key shortcut.
Why do arrow keys move the cursor inside a cell?
The cell is probably in edit mode. Press Enter to finish the edit or Esc to cancel it, then click the cell and use the arrow keys for worksheet navigation.
Why does the sheet still scroll when I press an arrow key?
If the active-cell border also moves, Excel is keeping the selected cell visible as it reaches the edge of the window. That is normal. Frozen panes can make part of the grid remain fixed while the rest scrolls.
Does Scroll Lock change or damage my workbook?
No. It changes how the keyboard’s arrow keys behave in the current environment; it does not alter cell values or formatting. Turn it off to return to ordinary cell-by-cell navigation.
Related
- Close Group Excel Shortcut: Close Workbooks and Rows
- Close Excel Shortcut: Windows and Mac Keys
- Checklist Template Excel: Set Up, Track, and Reuse Tasks
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Data Validation: Create Rules and Drop-Down ListsTo validate entries in Excel for Microsoft 365 on Windows, select the cells, choose Data > Data Validation…
- Clear Cache in the New Outlook App on WindowsTo clear the cache in the new Outlook app for Windows, close Outlook, then use Windows Settings to…
- Excel Find and Replace Part of a String in a Cell or RangeTo replace part of a string in Excel, press Ctrl+H on Windows, enter the text to find and…
- Add a Custom Number Format in Excel: Steps & ExamplesTo add a custom number format in Excel for Microsoft 365 on Windows, select the cells, press Ctrl+1,…
- Excel Yellow Color Code: RGB, Hex, and Theme ValuesExcel’s standard pure-yellow fill is RGB 255, 255, 0, written in hexadecimal as #FFFF00. Choose the yellow square…
- How to Make a Flowchart in Word 2019, Step by StepTo make a flowchart in Word 2019, choose Insert > Shapes, select a flowchart shape, and draw it…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.