What is Scroll Lock?
Usually, the arrow keys will move you one cell at a time in whatever direction you wish.
However, when Scroll Lock is enabled, the worksheet is “scrolled” instead.
The active cell never changes.
If you have a Scroll Lock key on your keyboard, just press it to toggle Scroll Lock off.
No key for Scroll Lock?
Unfortunately, it’s harder to disable Scroll Lock if your keyboard doesn’t have a Scroll Lock key.
How can you press a key you don’t have?
The rest of this article explains how to do that on both Mac and Windows.
Is Scroll Lock really on?
First, verify Scroll Lock is really enabled.
Yes, Scroll Lock is turned on.
(I haven’t checked Excel 2016 yet).
If the address doesn’t change, Scroll Lock is probably turned on.
Mac Excel 2011 doesn’t show scroll lock status anywhere.
That should do it.
If you have an extended keyboard with an F14 key, try that first.
One of the things you could do with AppleScript is send keystrokes to an program.
While researching this problem, I ran into a nice AppleScript by Damien Clarkhere.
However, I couldn’t get the script work like I expected.
I couldenableScroll Lock with the script.
But when I ran the script again, Scroll Lock wasn’tdisabled.
This works on my 2015 MacBook Pro reliably to turn Scroll Lock on and off.
If Scroll Lock is currently on, it should be disabled.
