- Use the Scroll Lock key on your keyboard to turn it off on Excel.
- You can also open up the On-Screen Keyboard, and press the Scroll Lock key to disable Scroll Lock in Excel.
- Alternatively, you can also run a macro to turn off Scroll Lock on Excel.
How to Check if Scroll Lock Is Enabled on Excel
If you’re unsure whether scroll lock is enabled on Excel, glance at the status bar in the bottom corner of the spreadsheet. You’ll see an indication that says ‘Scroll Lock’.
If you don’t see it, right-click on the status bar. Check if it says ‘on’ next to Scroll Lock in the list of options.
Ensure you check the Scroll Lock option on this list so that there’s an indication in the status bar if it is enabled.
How to Unlock Scroll Lock on Excel
Here are three ways to turn off the scroll lock in Microsoft Excel. Let’s begin.
Method 1: Disable the Scroll Lock Using the Keyboard Shortcut
If you observe closely, you will notice that your Windows keyboard has a Scroll Lock key . When you use this key, it disables the scroll lock in the open application. Therefore, you can use this key to disable the scroll lock on Microsoft Excel.
On Mac: You can use the key combination fn + Shift + F12 to turn the scroll lock functionality on or off.
Method 2: Disable Scroll Lock Using On-Screen Keyboard (Windows)
If you don’t find the Scroll Lock key on your keyboard, don’t worry. There is an alternative method to do the same.
Windows has an on-screen keyboard option that provides a virtual set of keys you can use on your display. This keyboard has a scroll lock key, and you can use it to turn off the scroll lock while Excel is open.
Open the On-Screen Keyboard app from the start menu. You can search for the same using the search bar.
Once you open it, you can use the ScrlLk key to turn it off on Excel.
Also Read : How to fix Excel not scrolling smoothly on Windows
Method 3: Turn Off the Scroll Lock Using VBA
Alternatively, you can run a macro to turn off the scroll lock. Here’s how you can do it.
Step 1: Use Alt + F11 in Windows, or Option + F11 in Mac to open the VBA editor on Microsoft Excel.
Step 2: In the VBA editor, click on the Insert tab and choose Module to insert a new module.
Step 4: Copy and paste the following code into the module:
Sub TurnOffScrollLock()
Application.SendKeys "{SCROLLLOCK}"
End Sub
Step 5: Close the VBA editor.
Step 6: Press Alt + F8 in Windows, or Option + F8 in Mac. Select TurnOffScrollLock , and click Run to run the macro.
