How to turn off Scroll Lock in Excel

Quick answer: Press the Scroll Lock key once (Microsoft notes it’s usually labeled ScrLk). If your keyboard doesn’t have one, open the Windows On-Screen Keyboard and select its ScrLk button. To confirm the change, look at the status bar at the bottom of the Excel window: the words Scroll Lock disappear when it’s off. If they never showed up, right-click the status bar and select Scroll Lock so Excel displays the indicator.

Applies to: Excel for Microsoft 365, Excel 2024, Excel 2021, Excel 2019 and Excel 2016 on Windows 11 and Windows 10, the desktop versions Microsoft lists on its Turn off Scroll Lock page. Mac and browser notes are in their own section below.

What Scroll Lock changes in Excel

Scroll Lock decides what the arrow keys move. With it off, an arrow key moves the selected cell to the next one. With it on, Microsoft’s Turn off Scroll Lock page describes the arrow keys as moving between rows and columns instead of cells: the worksheet view shifts while the selection stays where it was. That’s why a sheet with Scroll Lock on can feel as if the arrow keys have stopped working.

There is one deliberate use for it. Excel’s keyboard shortcuts list says that pressing Home while Scroll Lock is on jumps to the cell in the upper-left corner of the window, rather than to column A. If you didn’t turn it on for something like that, switching it off is safe and changes nothing in your workbook.

Scroll Lock is a setting of the keyboard, not of the file. As a general rule, switching it off in one place switches it off for Windows as a whole, so you don’t have to repeat the step for each workbook.

Check whether Scroll Lock is on

Microsoft says Excel shows Scroll Lock on the status bar, the strip along the bottom of the window, whenever the feature is on. If the arrow keys scroll the sheet but you see no indicator, the status bar may simply be set to hide it:

  1. Right-click anywhere on the status bar.
  2. In the list that opens, select Scroll Lock so a check mark appears next to it.
  3. Click back into the sheet. From now on, the status bar shows the indicator while Scroll Lock is on.

Turning the indicator on doesn’t change Scroll Lock itself. It only lets you see its state, which makes the methods below easy to confirm.

Method 1: Press the Scroll Lock key

On a full-size keyboard, look for the key in the group with Print Screen and Pause, above the arrow and navigation keys. Its label may read Scroll Lock, ScrLk or ScrLock, depending on the keyboard.

  1. Click a cell in Excel so the workbook window has focus.
  2. Press the Scroll Lock key once.
  3. Check the status bar: the Scroll Lock indicator should be gone. Press an arrow key and the selected cell should move again.

Some keyboards have a small Scroll Lock light that goes out when the feature is off. If the indicator is still showing, you may have pressed the key twice, so press it once more.

Method 2: Use the On-Screen Keyboard

Some compact keyboards and laptops leave out the Scroll Lock key. Microsoft’s answer for that case is the On-Screen Keyboard built into Windows, which has its own ScrLk button.

  1. In Windows 11, open Start > Settings > Accessibility > Keyboard and turn on the On-Screen Keyboard toggle. In Windows 10, the same toggle is under Settings > Ease of Access > Keyboard.
  2. Select the ScrLk button on the keyboard that appears. As general guidance, the button changes color while Scroll Lock is on, and its normal color returns when it’s off.
  3. Check the Excel status bar, then close the On-Screen Keyboard with the X in its upper-right corner.

A quicker way in: Microsoft’s Scroll Lock page suggests finding the On-Screen Keyboard by searching from the Start button. Typing osk or On-Screen Keyboard in Start search should bring it up, though Microsoft’s own On-Screen Keyboard article only gives the Settings route. If the keyboard then keeps opening by itself, see how to stop the on-screen keyboard popping up in Windows 11.

Method 3: Laptops without a Scroll Lock key

Some laptops put Scroll Lock on a second function of another key, which you reach by holding Fn. Microsoft doesn’t list these combinations, and they differ between manufacturers and even between models, so check the laptop’s manual or the maker’s support site for your model.

Avoid trying Fn combinations at random. On a laptop, Fn keys can also turn off Wi-Fi, the touchpad or the display. The On-Screen Keyboard in Method 2 works on any Windows laptop and doesn’t depend on the key layout.

Excel for Mac and Excel for the web

Mac: Microsoft’s Turn off Scroll Lock page has no Mac steps, and you may not find a key labeled Scroll Lock on a Mac keyboard. If you use a full-size keyboard with an F14 key, you can try pressing F14, or Shift + F14, and then test the arrow keys. This isn’t documented on the Microsoft pages used for this guide, so treat it as something to try rather than an official step.

Excel for the web: the Turn off Scroll Lock page doesn’t list Excel for the web either. In a browser, key presses go through the browser first, so behavior may differ from the desktop app. On a Windows PC, pressing Scroll Lock or using the On-Screen Keyboard is still the first thing to try if the arrow keys scroll the sheet in Excel for the web.

Arrow keys still not moving the cell?

If Scroll Lock is off and the arrow keys still misbehave, something else is changing their behavior, such as edit mode, End mode, Extend Selection or an add-in. The Excel arrow keys not working guide works through each of those.

Two sheet settings can also look like a keyboard problem. Frozen rows and columns stay put while the rest of the sheet moves, which the Freeze Panes guide explains, and a hidden scroll bar makes it harder to tell where you are, which the Excel scroll bar guide covers.

Match what you see to the fix

What you seePossible causeWhat to try
Arrow keys scroll the sheet, the selected cell stays putScroll Lock is onMethod 1 or Method 2
No Scroll Lock indicator, but the sheet scrollsIndicator hidden on the status barRight-click the status bar, select Scroll Lock
Keyboard has no ScrLk keyCompact or laptop keyboardMethod 2, or Method 3 with the manual
Indicator gone, arrows still don’t move the cellEdit mode, End mode or another settingExcel arrow keys guide
Home goes to the window’s top-left cell, not column AScroll Lock is onTurn it off if you didn’t mean to use it

Sources

How we write our guides: read our editorial policy.

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *