Scroll Lock in Excel: How to Turn It On

How-to basics · Updated November 21, 2026

To turn on Scroll Lock in Excel for Microsoft 365 on Windows, press the Scroll Lock or ScrLk key once. If your keyboard has no such key, open Windows On-Screen Keyboard and click ScrLk. With Scroll Lock on, the arrow keys scroll the worksheet instead of moving the active cell. Use the same key or on-screen button again to turn it off.

What You’ll Need

  • Excel for Microsoft 365 for Windows, ideally with a workbook open so you can check the effect.
  • A physical keyboard with a Scroll Lock key, or access to Windows On-Screen Keyboard.
  • For a laptop, the keyboard model or its function-key instructions may help because Scroll Lock can be combined with an Fn key or omitted entirely.

You do not need to change the workbook, edit a cell, or open Excel settings. Scroll Lock is a keyboard state, and the main check is what happens when you press an arrow key while a worksheet is active.

Step-by-Step

  1. Open a worksheet and identify the active cell. Click an ordinary cell, such as B3, so Excel has focus. Note its selection border and the row and column headings. This gives you a clear reference for checking whether the arrow keys move the selection or scroll the view. If you are currently editing text inside a cell or the formula bar, press Enter or Esc first; otherwise the arrow keys may move the text cursor rather than show Scroll Lock behavior.
  2. Press the Scroll Lock key once. Look for a key labeled Scroll Lock, ScrLk, or a shortened version of either label. It is often near Print Screen, Pause, or the navigation keys on a full-size keyboard. Press it briefly, then return to Excel. This toggles the setting on; holding the key down is not necessary. If you are unsure whether it registered, use the arrow-key check in the next step rather than pressing it repeatedly.
  3. Check the arrow-key behavior. Press the Down Arrow once. When Scroll Lock is on, the visible worksheet should move downward while the active cell remains selected. Press an arrow key in another direction to confirm the view scrolls that way too. With Scroll Lock off, the active-cell border normally moves from one cell to another when you press the arrow keys. The sheet may move only a small amount for a single key press, so watch the selection border as well as the row numbers.
  4. Check Excel’s status bar if you want a visible indicator. At the bottom of the Excel window, right-click the status bar. In the menu, select Scroll Lock if it appears as an available item. Excel will then show a Scroll Lock indicator in the status bar when the feature is active. The status bar menu contains display options, so selecting the item makes the indicator visible; it is not a separate way to toggle the keyboard state. If you do not see the item at first, make sure you are right-clicking the bottom status bar rather than a worksheet cell.
  5. Use Windows On-Screen Keyboard if your physical keyboard lacks the key. Open the Windows Start menu, type On-Screen Keyboard, and launch the matching app. In Windows 11, you can also go to Settings > Accessibility > Keyboard and turn on On-Screen Keyboard. In Windows 10, go to Settings > Ease of Access > Keyboard and turn on Use the On-Screen Keyboard. With Excel in focus, click the on-screen ScrLk key once. Return to the worksheet and test an arrow key. Click ScrLk again when you want to switch the behavior back.
  6. Try the laptop’s function-key combination if needed. Some laptop keyboards place Scroll Lock on another key as a secondary label. Look for ScrLk printed in a smaller color or font, then try pressing Fn with that key. The exact combination varies by manufacturer and model; there is no single Windows laptop shortcut that works on every device. If the label is unclear, check the laptop’s keyboard guide or support page rather than trying combinations at random. You can use On-Screen Keyboard instead if you cannot identify the shortcut.

On a Mac: Excel for Mac can toggle Scroll Lock with Shift+F14. If your function keys control features such as brightness or volume, you may need to press Fn+Shift+F14. Some compact Mac keyboards do not have an F14 key, so this shortcut may not be available on the built-in keyboard; an extended keyboard with F14 or Scroll Lock may be needed. The Windows On-Screen Keyboard directions above do not apply to macOS.

In Excel for the web: Keyboard behavior can depend on the browser and the keyboard, and some browsers may handle keys differently from the desktop app. If you need Scroll Lock specifically to control worksheet scrolling, try the Windows desktop version of Excel and use the steps above.

Common Mistakes

  • Pressing the key more than once while checking. Scroll Lock is a toggle: one press turns it on and another turns it off. If you press it twice because the first result was not obvious, you may end up back where you started. Press once, then deliberately check the cell border and worksheet position.
  • Confusing worksheet scrolling with moving the active cell. The screen can move in both cases, especially if the selected cell reaches the edge of the visible area. Look at the selected-cell border and row numbers. With Scroll Lock on, the view moves while the same cell remains active; without it, the active selection changes as you navigate.
  • Trying to find a Scroll Lock switch in Excel’s ribbon. Excel does not provide a standard ribbon button for toggling this keyboard state. The usual methods are the physical key, a laptop’s mapped key combination, or the operating system’s on-screen keyboard. The status bar can display the state, but its menu is for choosing what appears there.
  • Assuming the key labeled Fn is Scroll Lock. Fn is a modifier on many laptops, not the toggle by itself. It works only with the particular key combination assigned by the laptop maker. Check the secondary labels or device instructions before treating Fn plus an unrelated key as the Scroll Lock shortcut.
  • Testing while editing a cell. When the insertion point is inside cell text or the formula bar, arrow keys can move through the text. Finish or cancel the edit before testing, then click a worksheet cell so the navigation behavior is easy to interpret.

Tips

  • Use the active-cell border as your main test. The status-bar indicator is convenient, but it can be hidden if Scroll Lock is not selected in the status-bar menu. The selection-versus-scroll behavior gives you a direct check even when no indicator is displayed.
  • Turn it off when ordinary navigation returns. When you are done scrolling with the arrow keys, press Scroll Lock or ScrLk once more. If you used On-Screen Keyboard, click its ScrLk button. Confirm that the active cell now moves when you press an arrow key.
  • Use the mouse or scroll wheel for normal sheet movement. Scroll Lock is most useful when you specifically want to keep the current cell selected while shifting the view. For routine navigation, the mouse wheel, scroll bar, or keyboard navigation with Scroll Lock off may be more predictable.
  • Remember that the state is not a workbook setting. Scroll Lock does not travel with a worksheet as a formatting choice or formula. If arrow-key behavior seems unusual in another spreadsheet or application, check whether the keyboard state is still on and toggle it off if needed.
  • Keep the status-bar indicator available if you use the feature often. Right-click the status bar and select Scroll Lock. The indicator makes it easier to notice the state before navigating, which can prevent confusion when a sheet appears to move unexpectedly.

Troubleshooting

Nothing happens when you press Scroll Lock. First click a worksheet cell to make sure Excel has focus, and make sure you are not editing cell contents. Then check the status bar after enabling its Scroll Lock display, or press an arrow key and watch the selection border. On some keyboards, the key is labeled ScrLk or shares a key with another function. If you cannot find it, use Windows On-Screen Keyboard and click ScrLk. If the on-screen key is not visible, open its Options and enable the numeric keypad display if that option is available, then check the keyboard again.

The arrow keys still move the selected cell. Scroll Lock may not have been enabled, or a laptop key combination may have sent a different command. Open On-Screen Keyboard and click ScrLk once, then test again. Avoid pressing both the physical and on-screen keys in quick succession, because each one toggles the same state. Also check that the worksheet is active and not in cell-edit mode. If the status-bar indicator is displayed, use it to see whether Excel reports Scroll Lock as active.

The worksheet scrolls, but I cannot tell whether the cell changed. Click a cell well inside the visible grid before testing, and note its address in the Name Box to the left of the formula bar. Press an arrow key once and compare the address and selection border. With Scroll Lock on, the address should stay the same while the view shifts. If the active cell is near the edge of the window, the movement may be easier to see by using a larger worksheet area or testing from a cell nearer the center.

I cannot find ScrLk on the On-Screen Keyboard. Confirm that you opened the Windows On-Screen Keyboard rather than a third-party keyboard app. Its layout may differ with the selected display options. Open Options and look for the numeric-keypad display setting, then enable it if available. If the key still is not shown, use your keyboard manufacturer’s instructions or a compatible external keyboard with a Scroll Lock key. Do not assume that Num Lock or Caps Lock will produce the same effect; they control different keyboard functions.

The shortcut does not work on my Mac. Check whether your keyboard has an F14 key and try Shift+F14. If the function row is assigned to hardware controls, try Fn+Shift+F14. A compact keyboard may not provide F14 at all, and the exact available key combinations depend on the device. Use a keyboard with the needed key if the shortcut is unavailable, and make sure Excel—not another app—has focus when you test it.

Frequently Asked Questions

What does Scroll Lock do in Excel?
It changes how navigation keys such as the arrows affect the worksheet. With Scroll Lock on, the view scrolls while the active cell remains selected. With it off, arrow keys normally move the selection between cells.

How do I turn Scroll Lock off again?
Press the physical Scroll Lock or ScrLk key once, click ScrLk in Windows On-Screen Keyboard, or use the same laptop key combination that turned it on. Check that pressing an arrow key moves the active cell.

Can I turn it on from an Excel menu?
There is no standard Excel ribbon command that toggles Scroll Lock. Use a keyboard key or the operating system’s on-screen keyboard. Excel’s status-bar menu can show the indicator, but displaying it does not switch the state on or off.

Does Scroll Lock change my formulas or data?
No. It changes keyboard navigation behavior, not cell contents, formulas, formatting, or workbook calculations. Turning it on or off does not edit the selected cell.

Will closing the workbook turn Scroll Lock off?
Do not rely on closing a workbook to reset it. The state comes from the keyboard or operating environment rather than being saved as a workbook setting. Toggle it off and verify normal arrow-key movement when you are finished.

Why is there no Scroll Lock key on my laptop?
Many compact keyboards omit a dedicated key or place the function behind a manufacturer-specific shortcut. Check for a secondary ScrLk label and the laptop’s documentation, or use Windows On-Screen Keyboard to toggle it without a physical key.

Related

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.