If Excel’s arrow keys move the worksheet view instead of moving the selected cell, Scroll Lock is usually turned on. Turn it off by pressing the Scroll Lock key; if your keyboard lacks that key, use Windows On-Screen Keyboard and click ScrLk.
Why Excel’s arrow keys move the screen
In Excel for Microsoft 365 on Windows, the arrow keys normally move the active-cell selection one cell at a time. With Scroll Lock enabled, the arrows instead scroll the worksheet viewport while leaving the active cell where it is. That difference can make it seem as if the keyboard has stopped responding: the visible rows or columns change, but the highlighted cell does not.
Scroll Lock is a keyboard mode originally used by some programs to change how cursor keys behave. Excel retains support for it. When it is on, pressing the right arrow can shift the displayed worksheet horizontally, while pressing the down arrow can reveal rows farther down. The cell that was active before the scroll remains active, even if it moves out of the visible area.
With Scroll Lock off, Excel moves the active cell. If that movement takes the selection beyond the visible edge of the worksheet, Excel scrolls the view as needed to keep the selection in sight. That normal scrolling can look similar at first, but the key distinction is whether the active-cell border moves.
Turn off Scroll Lock in Windows
First, try the direct keyboard toggle:
- Click a worksheet cell so Excel is active.
- Press the key labeled Scroll Lock, ScrLk, or a similar abbreviation.
- Press an arrow key and check whether the selected cell now moves.
Scroll Lock is a toggle, so pressing the key changes its state. If it was already off, pressing it will turn it on. If the arrows begin scrolling the sheet after you press it, press the key again to return to normal cell navigation.
If there is no Scroll Lock key, Windows includes an On-Screen Keyboard:
- Open Start and search for On-Screen Keyboard. You can also press Windows key+Ctrl+O.
- In the on-screen keyboard, find the ScrLk button. It may be abbreviated or appear among the other keys.
- Click ScrLk, return to Excel, and test an arrow key.
In Windows 11, you can also open Settings > Accessibility > Keyboard and turn on On-Screen Keyboard. The keyboard appears on screen without replacing your physical keyboard; click its ScrLk key to toggle the setting. If the button is not visible, maximize the On-Screen Keyboard window or inspect its available keys.
Excel’s status bar can provide a clue. When Scroll Lock is active, Excel may display Scroll Lock at the bottom of the window. The status bar is customizable, however, and that indicator may not be shown. Right-click the status bar and look for the Scroll Lock item in its options. If it is available, selecting it can make the indicator visible; the status bar indicator reports the state rather than serving as the usual way to switch it off.
Scroll Lock on laptops and compact keyboards
Many laptops omit a dedicated Scroll Lock key to save space. Some place the function on a secondary key, often indicated by small lettering, and require holding Fn while pressing that key. The exact combination depends on the laptop maker and model, so do not assume that one shortcut works on every device. Check the keyboard labels or the manufacturer’s documentation for a Scroll Lock function.
Some external keyboards also hide the key behind an Fn layer or use a different abbreviation. If you cannot identify the combination, the Windows On-Screen Keyboard is a straightforward option and avoids guessing. It can also help distinguish a missing key from a keyboard that has a key but assigns it a less obvious label.
If you use a keyboard utility, remote desktop session, or a dock, the key press may be handled differently from what you expect. In that situation, check the Scroll Lock indicator in Excel, try the on-screen key, and test the arrows again. Avoid repeatedly pressing random Fn combinations, since some laptop shortcuts change display, volume, or other settings.
How to tell whether Scroll Lock is the cause
Watch the active-cell border while pressing an arrow key. If the worksheet moves but the border stays around the same cell, Scroll Lock is a strong possibility. If the border moves from one cell to another, Excel is receiving the arrow as a navigation command, even if the visible area shifts at the same time.
For example, suppose C5 is selected and rows 5 through 25 are visible. With Scroll Lock on, pressing Down can make lower rows appear while C5 remains the active cell. With Scroll Lock off, pressing Down selects C6. If C6 is near the bottom of the displayed area, Excel may scroll the view to show it; that is ordinary navigation, not the Scroll Lock behavior.
A quick check is to click a clearly identifiable cell, such as D10, then press Right once. If the selection remains on D10 while the view shifts, check Scroll Lock. If the selection changes to E10, the arrows are moving the active cell. If neither the view nor the selection changes, Excel may not have keyboard focus, or another interaction mode may be active.
Other reasons arrow keys may seem to behave oddly
Scroll Lock is common, but it is not the only explanation for unexpected arrow-key behavior:
- You are editing a cell. After pressing F2 or entering text directly in a cell, the arrows may move the text cursor within the cell or formula bar rather than select a different cell. Press Enter to accept the edit or Esc to cancel it, then try an arrow key again.
- The selection is moving normally and the view follows it. Excel scrolls when the active cell approaches or passes the visible edge. Look at the selected-cell border, not just the rows moving on screen.
- Freeze Panes or Split is in use. These viewing features keep some rows or columns in place while other parts of the sheet scroll. A stationary heading or region does not by itself mean Scroll Lock is enabled. Check View > Freeze Panes or View > Split if the sheet seems divided or partly fixed.
- Another window or control has focus. If focus is in a dialog, the formula bar, a worksheet control, or a different application, arrow keys may act there instead of navigating cells. Click an ordinary worksheet cell and test again.
- You are using a different scrolling input. A touchpad gesture, mouse wheel, or scroll bar can move the view independently of the active cell. If the sheet moves without a key press, check those inputs rather than changing Scroll Lock.
These checks help avoid changing a setting unnecessarily. In particular, do not confuse normal scrolling at the edge of the visible grid with Scroll Lock: normal movement changes the active cell, while Scroll Lock scrolling leaves it in place.
Excel on Mac and Excel for the web
On a Mac, the keyboard may not have a dedicated Scroll Lock key. On keyboards that provide F14, Microsoft Excel for Mac uses Shift+F14 to toggle Scroll Lock. Depending on the keyboard and macOS function-key settings, you may also need to hold Fn to send the F14 key. If your keyboard has no F14 key, consult its manufacturer’s instructions or use a keyboard that exposes the relevant key; Windows On-Screen Keyboard steps do not apply to macOS.
Excel for the web runs in a browser, so key handling can depend on the browser, operating system, and keyboard. If arrows scroll the browser page rather than moving between cells, first click a cell in the worksheet and try again. A desktop Excel shortcut or Scroll Lock workaround may not behave identically in the browser. For a workbook where keyboard navigation is essential, check the behavior in the version you are using rather than assuming that a Windows desktop setting controls the web app.
Frequently Asked Questions
Why do my arrow keys scroll in Excel instead of changing cells?
Scroll Lock is usually on. Toggle it off with the Scroll Lock key, or use Windows On-Screen Keyboard and click ScrLk if the key is missing. Then confirm that the active-cell border moves when you press an arrow.
How do I know if Scroll Lock is on in Excel?
Look for Scroll Lock in Excel’s status bar, if that indicator is enabled. You can also test a cell: if the sheet scrolls while the active-cell selection stays in place, Scroll Lock is likely on.
How do I turn off Scroll Lock without a Scroll Lock key?
In Windows, search Start for On-Screen Keyboard or press Windows key+Ctrl+O. Click ScrLk in the on-screen keyboard, then return to Excel and test an arrow key.
Why do arrow keys move the cursor inside a cell?
You may be editing the cell or its formula. Press Enter to finish the edit or Esc to cancel it. Once Excel is back in normal worksheet navigation, the arrows should move the active-cell selection.
Does Freeze Panes make arrow keys scroll the screen?
Freeze Panes can keep selected rows or columns visible while the rest of the worksheet scrolls, which can look unusual. It does not mean the active cell is fixed by Scroll Lock. Check whether the selection itself changes as you press the arrows.
Related
- Contacts List Template Excel: Build a Useful Workbook
- Contact List Excel Template: Free Options and Setup
- Contact List Format in Excel: Columns, Setup, and Tips
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Sum Text? What SUM Does With Text CellsIn Excel, SUM ignores text in a referenced range and adds the cells it recognizes as numbers. With…
- Find and Replace All in Word: Steps, Options, and TipsTo find and replace every match in Microsoft Word for Microsoft 365 on Windows, press Ctrl+H, enter the…
- Find the Financial Year From a Date in Excel EasilyTo find a financial year from a date in Excel, enter the date in A2 and use =YEAR(A2)+(MONTH(A2)>=4)…
- Blocking a Sender in Outlook: Steps and What to KnowTo block a sender in Outlook, select one of their messages and choose Block or Block Sender from…
- Hide Columns in Excel: How to Hide and Unhide ThemTo hide a column in Excel for Microsoft 365 on Windows, select its lettered heading, right-click it, and…
- Excel Linear Equation Solver for y = mx + b: A GuideTo calculate a value from y = mx + b in Excel, put the slope m, the intercept…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.