To unlock Scroll Lock in Excel for Microsoft 365 on Windows, press the Scroll Lock key once. If your keyboard does not have that key, open Windows On-Screen Keyboard with Windows key + Ctrl + O, then select ScrLk. When Scroll Lock is off, the arrow keys move the selected cell instead of scrolling the worksheet while leaving the selection in place.
This is useful when the sheet appears to move around but the active cell does not change as you press the arrow keys. Scroll Lock is a keyboard state, not a worksheet setting, so you normally do not need to edit the workbook or change an Excel option to turn it off.
What You’ll Need
- A Windows computer running Excel, and the workbook or worksheet where you noticed the behavior.
- Either a keyboard with a Scroll Lock key, or access to Windows On-Screen Keyboard if the key is missing or hard to reach.
- On a laptop, you may need the manufacturer’s function-key combination. The exact combination varies by model, so check the key labels or your laptop documentation.
If you use Excel for Mac, see the Mac note in the steps below. Excel for the web can also respond differently depending on the browser and keyboard, so the desktop Windows instructions are the most direct guide for the standard Windows app.
Step-by-Step
- Check the behavior. Click a cell in the worksheet, then press an arrow key once. With Scroll Lock on, Excel generally scrolls the visible worksheet while the active cell remains selected. With Scroll Lock off, the selection moves to a neighboring cell. If the arrow key is moving the selection already, Scroll Lock may not be the cause; read Troubleshooting before changing other settings.
- Try the Scroll Lock key. Find the key marked Scroll Lock, ScrLk, or a similar abbreviation, often near the top-right of a full-size keyboard. Press it once while Excel is open. The key toggles the state, so pressing it repeatedly switches Scroll Lock on and off; do not keep pressing it if the arrow keys begin behaving normally.
- Test the worksheet again. Click a cell that is not being edited and press an arrow key. The selected cell should move one cell in that direction. The worksheet may shift at the edge of the visible area as the selection moves, which is normal; the important difference is that the active cell changes along with the movement.
- Use the Windows On-Screen Keyboard if there is no physical key. Press Windows key + Ctrl + O to open it. Alternatively, open Start, search for On-Screen Keyboard, and launch the matching Windows app. On some Windows versions, you can also find it under Settings > Accessibility > Keyboard; in Windows 10, the setting is under Settings > Ease of Access > Keyboard.
- Click ScrLk once in the On-Screen Keyboard. The button may appear as ScrLk rather than Scroll Lock. Return to Excel and test an arrow key. If the selection moves cell by cell, Scroll Lock is off. The On-Screen Keyboard can remain open while you check; close it afterward if you no longer need it.
- Check the Excel status bar if you want confirmation. Look along the bottom edge of the Excel window for a Scroll Lock indicator. If it is not visible, right-click the status bar and look for Scroll Lock in the list of available indicators; select it if it is offered. The status-bar display is a useful clue, but the arrow-key test is the practical confirmation that matters.
- If you use Excel for Mac, try the Mac shortcut. On a keyboard that has an F14 key, press Shift + F14 to toggle Scroll Lock. A compact keyboard may require holding Fn as well, or may not provide F14 at all. Function-key behavior depends on the keyboard and macOS settings; if the shortcut is unavailable, use a compatible external keyboard with F14 or check the keyboard maker’s guidance. Do not use the Windows On-Screen Keyboard steps on a Mac.
There is no separate Excel ribbon command called Unlock Scroll Lock. The physical key or the Windows on-screen key changes the keyboard state; Excel then responds to that state. If you are using Excel in a browser and the key does not seem to work, test in the desktop app if available, or try the on-screen key and check the behavior again.
Common Mistakes
- Pressing the key more than once. Scroll Lock is a toggle: one press changes the current state, and the next press changes it back. If arrow keys work after a press, stop there rather than pressing again.
- Assuming every laptop has the same Fn shortcut. Some laptops place Scroll Lock behind a function layer, while others omit it. A combination that works on one brand or model may do nothing on another. Use the key markings or the manufacturer’s documentation instead of guessing a series of Fn combinations.
- Confusing Scroll Lock with a frozen pane. Freeze Panes keeps rows or columns visible as you scroll; it does not normally stop arrow keys from changing the active cell. Turning off Scroll Lock will not remove frozen rows or columns.
- Testing while editing a cell. If the insertion point is inside a cell or the formula bar, keyboard input can behave differently. Press Esc to cancel the current edit, or Enter to commit it, then click a worksheet cell and try the arrow key again.
- Relying only on the status bar. The Scroll Lock indicator may not be shown, or the status bar may be customized. Test the active-cell movement as well rather than treating a missing label as proof that Scroll Lock is off.
Tips
- Look at the Name Box as you test. It is the small box to the left of the formula bar that displays the active cell address, such as A1. When Scroll Lock is off, pressing an arrow key should normally change that address as the selection moves. This gives you a visible check even if the worksheet has similar-looking cells.
- Keep the on-screen keyboard handy for a compact laptop. If you need to toggle Scroll Lock occasionally and your keyboard lacks the key, Windows On-Screen Keyboard is a straightforward alternative. Pinning or reopening it is often simpler than memorizing a model-specific combination.
- Check which Excel window has focus. Click inside the worksheet before using the key. If another program, a dialog box, or a text field has focus, the keyboard input may not produce the Excel behavior you expect.
- Remember that scrolling itself is not always a problem. When the selection reaches the edge of the visible grid, Excel can move the view to keep the active cell on screen. Scroll Lock is specifically suggested when the view moves but the selected cell stays put as you press an arrow key.
- Use the appropriate shortcut for your platform. The Windows Scroll Lock key and Windows on-screen key are not the same as the Mac Shift + F14 shortcut. If you move between computers, check the keyboard state and platform rather than assuming the same key combination applies everywhere.
Troubleshooting
The arrow keys still scroll after pressing Scroll Lock. First, click a normal cell in the worksheet and test again. If the physical key may not be recognized, open On-Screen Keyboard with Windows key + Ctrl + O and click ScrLk once. Then test the active cell. If it starts moving, the key press changed the state. If the behavior changes in the opposite direction, click ScrLk once more and test again, because the button toggles rather than issuing a dedicated off command.
The ScrLk button is missing or the On-Screen Keyboard will not open. Search for On-Screen Keyboard from Start rather than relying on the shortcut. Confirm that you opened the built-in Windows keyboard and not a third-party keyboard utility. If you are using a managed work computer and accessibility tools are restricted, ask your IT support team or use a physical keyboard that has Scroll Lock.
The active cell still does not move, but Scroll Lock seems off. Press Esc to leave cell-edit mode, close any open dialog, and click a worksheet cell before testing. Also check whether the workbook is in a mode that changes navigation, or whether another application has captured the key. For a quick comparison, open a new blank workbook and try the arrows there. If they work in the blank workbook, the original sheet or current selection is a more likely source of the difference than Scroll Lock.
The status bar does not show Scroll Lock. Right-click the status bar and see whether Scroll Lock is available to display. If it is not listed, rely on the arrow-key test instead. Excel’s status-bar indicators can vary with the app state and customization, so an absent label does not necessarily mean anything is broken.
You are using Excel for the web. Browser focus and keyboard handling can affect what happens when you press Scroll Lock. Click a cell in the grid, try the on-screen key on Windows, and test again. If the behavior remains confusing, open the workbook in the Excel desktop app, if available, to separate browser input behavior from Excel’s worksheet navigation.
You are on a Mac and Shift + F14 has no effect. Check whether the keyboard actually provides F14 and whether the Fn key is needed to send function-key input. Some compact keyboards do not have a usable F14 key. Use a compatible external keyboard or the keyboard maker’s instructions; Windows-only OSK instructions do not apply to macOS.
Frequently Asked Questions
What is the Excel shortcut to turn off Scroll Lock?
On Windows, press the keyboard’s Scroll Lock or ScrLk key once. If it is not on your keyboard, open Windows On-Screen Keyboard with Windows key + Ctrl + O and click ScrLk.
How can I tell whether Scroll Lock is on?
Press an arrow key in a worksheet. If the visible area scrolls while the active cell stays selected, Scroll Lock is likely on. If the active cell moves, it is off. Excel may also show a Scroll Lock indicator on the status bar if that indicator is enabled.
Why do my arrow keys scroll instead of moving between cells?
Scroll Lock is the most common explanation when the worksheet view moves but the selection stays in place. Press Scroll Lock once, or toggle ScrLk in the Windows On-Screen Keyboard, then test the arrow keys again.
Does turning off Scroll Lock change or damage my workbook?
No. It changes keyboard navigation behavior, not the workbook’s cell contents or layout. You do not need to save the file just to change Scroll Lock, though you should save any other edits you have made.
What is the Scroll Lock shortcut on a Mac?
In Excel for Mac, use Shift + F14 on a keyboard that has F14. Depending on the keyboard, you may need to hold Fn as well. If the keyboard lacks F14, use a compatible external keyboard or check its documentation for a way to send that key.
Will Scroll Lock stay off after I close Excel?
Scroll Lock is a keyboard state rather than a setting saved in a workbook, so do not assume that closing a file resets it. If arrow keys behave unexpectedly in a later session, check the behavior and toggle the key if needed.
Related
- How to Split an Excel File in Half: A Step-by-Step Guide
- How to Split an Excel File Into Smaller Files Safely
- How to Split an Excel Sheet in Half Using Split Panes
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Insert a Bold Line in WordTo insert a bold horizontal line in Microsoft Word, place the cursor in a blank paragraph, open Home…
- Excel European Number Format: Decimals and SeparatorsTo use a European-style number format in Excel for Microsoft 365 on Windows, set the decimal and thousands…
- How to Move Tabs in Excel With the KeyboardTo move a worksheet tab in Excel for Microsoft 365 on Windows without using the mouse, press Alt,…
- Google Sheets: Count Unique Values in a Column EasilyTo count distinct values in a Google Sheets column, use =COUNTUNIQUE(A2:A) when the data starts in A2. To…
- Excel New Paragraph in Cell: Line Breaks ExplainedTo start a new paragraph inside an Excel cell in Microsoft 365 for Windows, edit the cell, place…
- Excel Freeze Panes Shortcut: Keys and How It WorksIn Excel for Microsoft 365 on Windows, select the cell below and to the right of the rows…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.