How to disable Scroll Lock in Excel Best article

Your report is due in an hour. You’re working along in Excel, things are going fine, when suddenly you notice that you can no longer move around properly. You press the arrow keys, but instead of the cursor moving to another cell, the entire worksheet seems to be moving about. WTF?! 

Before you panic and call support to tell them Excel is broken, check to see if Scroll Lock has been accidentally enabled. 

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 up and down arrow keys scroll one row up and down, and the right and left arrow keys scroll one column right and left. The active cell never changes.

If you don’t understand what’s going on, this can be quite distressing 🙂

The evil scroll lock, here to ruin your day

Fortunately, the Scroll Lock setting is a toggle, much like Caps Lock. If you have a Scroll Lock key on your keyboard, just press it toggle Scroll Lock off. Done.

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 “trick” is to figure out how to send the equivalent of the Scroll Lock keystroke to Excel. The rest of this article explains how to do that on both Mac and Windows.

Is Scroll Lock really on?

First, make sure Scroll Lock is really enabled.

On Windows, the status bar will display Scroll Lock if Scroll Lock is toggled on, and if the Scroll Lock status is enabled in the status bar. If Scroll Lock status is not enabled in the status bar, it might be toggled on and you’ll never see it.

Right click the status bar to make sure Scroll Lock status is enabled:

Scroll lock state enabled in Excel status bar

The Scroll Lock setting here doesn’t control Scroll Lock, it only displays Scroll Lock status.

Once you make sure that the Scroll Lock status is on, look for the Scroll lock message in the lower left.

Yes, scroll lock is enabled

Yes, Scroll Lock is turned on.

On a Mac, as far as I know, Scroll Lock status will not appear in the status bar of Excel 2011. (I haven’t checked Excel 2016 yet). The only way I know to verify the Scroll Lock state is to use the arrow keys and observe behavior. Try moving around with the arrow keys and watch the address in the name box (directly left of the formula bar). If the address doesn’t change change, Scroll Lock is probably turned on.

No scroll lock status on Mac 2011 status bar

Mac Excel 2011 doesn’t show scroll lock status anywhere.

How to disable Scroll Lock on Windows

If you’re using a full keyboard in Windows – one that has a Scroll Lock key – simply press the key to disable. You should see the Scroll Lock message disappear from the status bar and then be able to move around normally.

If your keyboard does not have a Scroll Lock key, you can access a virtual keyboard in Windows via Start > All Programs > Accessories > Ease of Access > On-Screen Keyboard.

Windows virtual keyboard

The On-Screen Keyboard in Windows, Scroll Lock key in white

Once the keyboard is displayed, make sure Excel is the active application and click the ScrLk key. That should do it. 

How to disable Scroll Lock on a Mac

The official Microsoft shortcut for Scroll Lock is Shift + F14. If you have an extended keyboard with an F14 key, try that first.

Mac Extended Keyboard with F14 key highlighted

A Mac Extended Keyboard has an F14 key (click to enlarge)

If you have a Macbook Pro, or other machine with a smaller keyboard that does not have extended keys, you’ll have to go a little deeper.

You’d think that you could go System Preferences > Keyboard, then enable an extended virtual keyboard, then use that to press F14. But, after an hour so of fiddling around, I couldn’t get it to work, and I’m not sure it can be done.

It seems that the Mac is “aware” of the keyboard currently attached, and uses this information to display the virtual keyboard. If you know a way to enable an extended virtual keyboard (on a Mac that doesn’t have one attached), please let me know.

Virtual Keyboard, a commercial freeware utility by Corallo Software (14 day trial) seems to work, but I did very little testing.

AppleScript to the rescue

On Macs, AppleScript is a built-in scripting language that can be used to automate applications and other general tasks. One of the things you can do with AppleScript is send keystrokes to an application.

While researching this problem, I ran into a nice AppleScript by Damien Clark here. However, I couldn’t get the script work like I expected. I could enable Scroll Lock with the script. But when I ran the script again, Scroll Lock wasn’t disabled.

At least not without checking the “use all F1, F2, etc keys as standard function keys setting” checkbox in the Mac’s keyboard preferences…which made the process pretty confusing.

So, after a bit more investigation (read: a few hours flailing about), I adapted the script to send the equivalent of fn + shift + F14, with a small delay. This works on my 2015 Macbook Pro reliably to turn Scroll Lock on and off.

-- Workaround to enable and disable Scroll Lock in Excel on the Mac
-- For Macs that don't have an F14 key available
-- Tested on 2015 MBP running Mac OS 10.10.5 and Excel 2011 (14.5.8)
-- Dave Bruns, December 10, 2015
 
activate application "Microsoft Excel"
delay 0.5 -- time to release modifier keys
tell application "System Events"
    key code 63 -- fn key
    key code 107 using shift down
end tell

To use this script, run the AppleScript Editor, create a new file, and paste in the code above. Then compile the script (Command + K), and run it (play button, or Command + R).

If Scroll Lock is currently on, it should be disabled.

Caution: if Scroll Lock is not currently enabled, it will be enabled, so you’ll need to run the script again to toggle it off again.

 

13 Responses

  1. imgur
    imgur at |

    As with any business venture, it is of the utmost importance to do your research before deciding to go in the
    business of web hosting reseller packages. Dream – Host is an online hosting company that offers products like domain registration, shared
    website hosting, Virtual Private Server (VPS), and public
    cloud services. You can be diligent about protecting your website but someone else on the same server might
    not be.

    Reply
  2. tranny
    tranny at |

    Thank you ever so for you blog post.Much thanks again. Really Cool.

    Reply
  3. http://london-excorts.com
    http://london-excorts.com at |

    Major thanks for the post.Really looking forward to read more. Really Great.

    Reply
  4. visit here
    visit here at |

    Thanks for the blog post.Thanks Again. Really Great.

    Reply
  5. website
    website at |

    Thanks a bunch for sharing this with all of us you actually know what you are talking about! Bookmarked. Kindly also visit my web site =). We could have a link exchange contract between us!

    Reply
  6. visit here
    visit here at |

    Muchos Gracias for your article post.Thanks Again. Really Cool.

    Reply
  7. website
    website at |

    Great, thanks for sharing this blog article.Much thanks again. Cool.

    Reply
  8. click here
    click here at |

    I dugg some of you post as I cogitated they were extremely helpful very helpful

    Reply
  9. website
    website at |

    Great post.Really looking forward to read more. Cool.

    Reply
  10. ezcorts-london
    ezcorts-london at |

    You made some nice points there. I did a search on the issue and found most persons will approve with your blog.

    Reply
  11. visit website
    visit website at |

    Major thanks for the article post.Much thanks again. Keep writing.

    Reply
  12. learn more
    learn more at |

    This is one awesome blog post.Thanks Again. Really Cool.

    Reply
  13. learn more
    learn more at |

    that’s good, thanks for your info,.. I think this is amazing blog

    Reply

Leave a Reply