TURN OFF SCROLL LOCK IN EXCEL HOW TO
TURN OFF SCROLL LOCK IN EXCEL PRO
TURN OFF SCROLL LOCK IN EXCEL WINDOWS

Whilst the scroll lock will hopefully solve your problem, it's worth noting that the keyboard arrow keys may also have caught dust and need cleaning up to function better.

When the on-screen keyboard appears on your screen, click the slk (scroll lock) button.

If your keyboard does not have a Scroll Lock key, on your computer, go to Start, All Programs, Accessories, Ease of Access, and then click On-Screen Keyboard. The Scroll Lock key on a Dell computer keyboard is gradually fading away as Dell manufacturers are not including it on their modern computers.

TURN OFF SCROLL LOCK IN EXCEL HOW TO

How to fix malfunctioning arrow keys without Scroll Lock? Step 2: Uncheck the Scroll Lock in this list, it will not show in status bar even if the scroll lock is enabled. See that the Scroll lock is OFF currently. Here, you can get the status of Scroll lock. However, we can also verify by trying to move the arrow keys while looking at the formula bar at the same time. Step 1: Right-click on the Excel status bar that will show you a list containing several options will open. Just turn it off by pressing on the Scroll Lock button key on your keyboard! We cannot find the Scroll Lock Status in the Status bar of Excel 2011 but we may find it in later Excel versions.

How to fix malfunctioning arrow keys with Scroll Lock?

This problem can have a particularly frustrating effect in Microsoft Excel, no longer being able to properly enter data in Excel cells and worksheets. On the screen keyboard, you can see the ScrLk button.When working on your computer, you arrow keys may stop functioning, as in they no longer move up and down correctly. There, you can see the “On Screen Keyboard” button.

Click the ScrLk button on the keyboard that appeared on the screen.Ĭlick Start > Settings > Ease of Access > Keyboard.

Go to Start > All Programs > Accessories > Ease of Access > On-Screen Keyboard.

TURN OFF SCROLL LOCK IN EXCEL WINDOWS

Here is how you may On/Off scroll lock by using on-screen keyboard on various Windows versions. In that case, you may use the virtual keyboard (available in your Windows) from turning the Scroll Lock Off. What if Scroll Lock key is not in the keyboard?Ĭhances are there is no scroll lock key at all in your keyboard but Excel still shows and behaves as if Scroll Lock is ON. Alternatively, you can use the Windows + I keyboard shortcut. Click on the Start menu in your taskbar (Windows icon) and choose Settings. Additionally, you may use the on-screen keyboard to toggle Scroll Lock on and off in Excel. While this key is on external keyboards of Apple, however, Macs usually don’t come with an F14 key and you would need to create your shortcut in Keyboard shortcuts in System Preferences. When the Excel application window is active, press this button on the keyboard to enable or disable Scroll Lock. Once the ScrLk key goes dark-grey, you know Scroll Lock is deactivated. The On-Screen Keyboard pops up, and all you have to do now is press the ScrLk button to turn scroll lock on/off.

TURN OFF SCROLL LOCK IN EXCEL PRO

In this tutorial, we will learn how to disable or enable the scroll Lock function using different ways, whether we have a MacBook, MacBook Pro or Windows Laptop. With the Scroll Lock Key, it becomes difficult to move from Cell to Cell. Normally, the Scroll Lock key should be with “Print Screen” and “Pause/Break” keys in your keyboard but it may vary from vendor to vendor.Ī small light indicating the Scroll Lock may also be visible, depending on the keyboard vendor. To disable scroll lock in Excel, Apple has a special set of keys. Now, Select Accessories > Ease of Access > On-Screen Keyboard from the menu. We can turn off or turn on the Excel Scroll Lock feature with or without our keyboard.

The immediate fix can be pressing again the “Scroll Lock” in the keyboard.

Note: If unchecked, the status of scroll lock “On” will not be visible. Upon right clicking, it not only tells whether currently, the Scroll Lock is On or Off but you may check/uncheck whether showing the Scroll Lock status in the status bar or not. For that, right click on the status bar and see if “Scroll Lock” is checked or unchecked. You may set to see the status of scroll lock in Excel’s status bar. The status bar is the one at the bottom with information like Sum, Average, Count etc. How to see if scroll lock is On/Off in Excel? Most chances are you have pressed the “ Scroll Lock” key in the keyboard either accidentally or for some other reason and as started working in Excel, the scrolling is in the worksheet rather than the normal cell to cell movement. If you suddenly start seeing navigating from cell to cell is stopped while pressing the arrow keys and rather navigating in the worksheet then your scroll lock is ON.

Turn off scroll lock in excel