To enable Scroll Lock in Excel for Microsoft 365 on Windows, press the Scroll Lock or ScrLk key; if your keyboard has no such key, open Windows’ On-Screen Keyboard and click ScrLk. When Scroll Lock is on, the arrow keys scroll the worksheet instead of moving the selected cell. Check Excel’s status bar to confirm the setting.
What You’ll Need
- A Windows computer running the Excel desktop app. The steps below are for Microsoft 365 on Windows; other desktop versions are similar.
- Either a keyboard with a Scroll Lock key or access to Windows’ On-Screen Keyboard. Laptop key combinations vary by manufacturer.
- An open workbook in which you can safely test the setting. Scroll Lock changes how navigation keys behave, not the workbook’s data.
Step-by-Step
- Open your workbook in the Excel desktop app. Select the worksheet where you want to use Scroll Lock. It is useful to click a cell away from the edge of the visible grid so you can clearly see the difference between moving the selection and scrolling the sheet. If the workbook is read-only, the navigation setting can still be used; you do not need to edit or save the file to toggle Scroll Lock.
- Try the Scroll Lock key on your keyboard. Look for a key labelled Scroll Lock, ScrLk, or sometimes Scr Lk. It is often near the Print Screen and Pause keys on a full-size keyboard. Press it once; it toggles the setting on. Some keyboards have a small indicator light, but the light is not a reliable check on every model. Use Excel’s status bar or the arrow-key test in the later steps to confirm.
- On a laptop, check for a function-key combination. Compact keyboards may omit a dedicated Scroll Lock key or print the abbreviation in a secondary colour on another key. Look for ScrLk printed on the keyboard, then press that key with Fn if the label indicates a secondary function. The exact combination differs between manufacturers and models, so check the laptop’s keyboard diagram or user guide if you cannot find the label. Avoid trying random Fn combinations, which may change brightness, sound, or other settings instead.
- Use Windows’ On-Screen Keyboard if there is no physical key. Open the Windows Start menu, type On-Screen Keyboard, and select the matching app. You can also open it through Settings: in Windows 11, go to Settings > Accessibility > Keyboard and turn on On-Screen Keyboard; in Windows 10, go to Settings > Ease of Access > Keyboard and turn it on. The Start-menu search method is generally the quickest.
- Click ScrLk on the On-Screen Keyboard. The on-screen keyboard may open with a compact layout. If you do not see ScrLk, use its Options button and enable the numeric keypad if the layout offers that choice; the key may then appear. Click ScrLk once to switch Scroll Lock on. Click it again later to turn the setting off. Leave the on-screen keyboard open temporarily if you want to check the key’s highlighted state.
- Check Excel’s status bar. Look along the bottom of the Excel window for the words Scroll Lock. If they are visible, Scroll Lock is on. If the indicator is not shown, right-click the status bar and look for Scroll Lock in the list of status-bar options. Select it if available to display the indicator. This controls whether Excel shows the status message; it does not itself turn the keyboard setting on or off.
- Test the arrow keys in the worksheet. With Scroll Lock on, click a cell in the grid and press an arrow key. The worksheet view should move while the selected cell remains the same. With Scroll Lock off, the arrow key normally moves the active-cell outline to a neighbouring cell. Pressing the Scroll Lock key again or clicking ScrLk on the On-Screen Keyboard returns to normal cell-by-cell navigation.
Common Mistakes
- Assuming the setting is a workbook option. Scroll Lock is a keyboard state, not a worksheet feature you turn on from the Excel ribbon. There is no general Scroll Lock button on the Home tab, and the setting does not require changing Excel Options.
- Confusing Scroll Lock with Freeze Panes. Freeze Panes keeps selected rows or columns visible as you move around a sheet. Scroll Lock changes how the arrow keys navigate. If headings remain fixed while the rest of the sheet moves, that may be Freeze Panes rather than Scroll Lock.
- Expecting it to stop every kind of scrolling. Scroll Lock is useful for navigating with the keyboard, particularly the arrow keys. It does not protect cells, lock the worksheet, or generally disable scrolling with a mouse wheel or touchpad. Those actions can still move the view.
- Pressing an Fn key without checking the label. Laptop shortcuts are not universal. A key that resembles the Scroll Lock combination on one model may control another feature on yours. Look for the ScrLk marking or consult the device documentation.
- Treating a missing status-bar label as proof that it is off. The Scroll Lock status indicator may be hidden. Check the status-bar options or test whether the selected cell stays put when you press an arrow key.
Tips
- Use Scroll Lock when you want to inspect nearby data without losing your place. For example, select a total near the top of a long worksheet, turn Scroll Lock on, and use the arrow keys to move the view through nearby rows. The active cell remains selected, making it easier to keep track of the cell you started from.
- Turn it off as soon as you finish. Scroll Lock can make Excel appear unresponsive if you expect arrow keys to move the cell selection. Toggling it off restores the usual navigation behaviour and can prevent confusion when you return to the workbook later.
- Keep the status-bar indicator visible if you use it often. Right-click the status bar and select the Scroll Lock entry if Excel offers it. A visible indicator makes it easier to spot the active state without opening the On-Screen Keyboard.
- Remember that the setting may affect other applications. Scroll Lock is managed by the keyboard and Windows, rather than saved as a property of a particular Excel file. If arrow-key behaviour seems odd after you leave Excel, check whether Scroll Lock is still on and toggle it off.
- Use normal scrolling for large jumps. Scroll Lock moves the view in response to keyboard navigation, but it is not a replacement for the vertical or horizontal scroll bars, the mouse wheel, or Go To. For a distant cell, use the Name Box or Excel’s Find and Go To commands instead of repeatedly pressing an arrow key.
Troubleshooting
The physical key does not seem to do anything. First click a cell in the worksheet, then press the key once and check the status bar or test an arrow key. Some keyboards require Fn to access a secondary ScrLk function, while others have an Fn Lock setting that changes how function keys work. Check the keyboard markings and your computer maker’s instructions. If the key is missing or broken, use the On-Screen Keyboard.
ScrLk is not visible on the On-Screen Keyboard. Confirm that you opened Windows’ On-Screen Keyboard rather than Excel’s built-in accessibility or dictation tools. Try opening it from Start-menu search. If its layout has an Options button, inspect the available layout choices and enable the numeric keypad if needed. On some layouts the key is not immediately visible; it may be necessary to resize the on-screen keyboard window.
The selected cell still moves when you press an arrow key. The setting may not have switched on, or Excel may not have focus. Click a worksheet cell and check whether the status bar says Scroll Lock. If it does not, press the physical key or click ScrLk once. If the indicator is hidden, right-click the status bar to show it, then test again. Make sure you are not typing inside a cell or using a dialog box, because keys can behave differently while those controls have focus.
The sheet moves, but the cell selection also seems to change. Check that you are looking at the active-cell outline rather than a cursor, a selected range, or the position of a pane. Click a single worksheet cell before testing. Also check for frozen or split panes, which can make part of the grid remain stationary while another part moves. Toggle Scroll Lock off and on once, then repeat the test with a single selected cell.
The Scroll Lock label is absent from Excel’s status bar. Right-click an empty area of the status bar and see whether Scroll Lock is an available item to display. The label only reports the state; hiding it does not turn Scroll Lock off. If the option is unavailable, use the arrow-key test or Windows’ On-Screen Keyboard to check the state instead.
You are using Excel for the web. The steps above target the Windows desktop app, where the status-bar indicator and Scroll Lock behaviour are easiest to check. In a browser, keyboard input can be handled by the browser or operating system, so behaviour may differ. If Scroll Lock does not work as expected in Excel for the web, open the workbook in the desktop Excel app and try the steps there.
You are using a Mac. Mac keyboards generally do not include a dedicated Scroll Lock key or Windows’ On-Screen Keyboard. Excel for Mac may toggle Scroll Lock with Shift+F14; on some keyboards you may need Fn+Shift+F14 to send the F14 key. The available shortcut depends on the keyboard and Mac settings. If it does not work, consult the keyboard maker’s instructions; the Windows steps and status-bar checks do not apply exactly to macOS.
Frequently Asked Questions
What does Scroll Lock do in Excel?
It changes keyboard navigation so that pressing an arrow key scrolls the worksheet view instead of moving the active-cell selection. It does not lock the sheet or prevent changes to data.
How can I tell if Scroll Lock is on?
Look for Scroll Lock on Excel’s status bar, if that indicator is enabled. You can also select a cell and press an arrow key: if the view moves while the selected cell stays in place, Scroll Lock is on.
How do I turn Scroll Lock off?
Press the Scroll Lock or ScrLk key again, use your laptop’s documented Fn combination, or click ScrLk again on Windows’ On-Screen Keyboard. Confirm that arrow keys move the active cell again.
Does Scroll Lock apply only to one workbook?
No. It is a keyboard state, not a setting saved inside a particular workbook. It can affect how you navigate in Excel while it is on, so check the state if the arrow keys behave unexpectedly.
Can I enable Scroll Lock from Excel’s ribbon?
No. Excel does not provide a standard ribbon command for turning it on. Use the keyboard, a laptop’s supported key combination, or Windows’ On-Screen Keyboard instead.
Will Scroll Lock stop my mouse wheel from scrolling?
Usually not. Scroll Lock primarily changes keyboard navigation in Excel. Mouse-wheel and touchpad scrolling are separate ways to move around the worksheet.
Related
- How to Delete Duplicate Entries in Excel
- How to Delete Certain Data in Excel Without Losing More
- How to Delete a Border Line in Excel: Quick Steps and Fixes
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Workbook Structure: Sheets, Cells, and FilesAn Excel workbook is the complete spreadsheet file: it contains one or more sheets, and each worksheet organizes…
- How to Compare Two XML Files in ExcelTo compare two XML files in Excel, import each one with Power Query, shape both into tables with…
- Excel Print Shortcut: How to Print a WorksheetIn Excel for Microsoft 365 on Windows, press Ctrl+P to open the Print screen, review the preview and…
- Freeze Panes in Excel: Keep Rows and Columns VisibleTo keep headings or labels visible while you scroll in Excel, use View > Freeze Panes. Choose Freeze…
- Excel Slicer Search: How to Find Items in a SlicerUsually, no: a standard slicer in Excel for Microsoft 365 on Windows does not provide the same always-available…
- Add a Watermark in Word on One Page: Step-by-Step GuideTo add a watermark to just one page in Word, isolate that page in its own section, unlink…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.