courtdilypo

Turn off Scroll Lock

※ Download: Shortcut key for scroll lock

That way, windows can be moved and resized very easily and naturally. Of course Alt + Tab but also Alt + Shift + Tab for going backwards. You press the arrow keys, but instead of the cursor moving to another cell, the entire worksheet seems to be moving about.

After you have followed what I have shown you how to solve the scroll lock, then if you could fix it out,… so that this is one of your answer s. No key for Scroll Lock? See screen shots below. Excel office is the real great invention for all over the operation and administration offices, I believe.

XL Toolbox Developer Blog - We, the general user, cannot understand everything about how they work.

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. 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. 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 : 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. 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, make sure Scroll Lock is really enabled. You can do this by working with the , the name for the bottom edge of the Excel Window, which displays various information about the state of the current worksheet. 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: 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 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. 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. 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. 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. But, after an hour so of fiddling around, I couldn't get it to work, and I'm not sure it can be done. If you know a way to enable an extended virtual keyboard on a Mac that doesn't have one attached , please let me know. 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. 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. 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. 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.

Try moving around with the arrow keys and watch the address in the name box directly left of the formula bar. Daniel's XL Toolbox is an independent software product and is not affiliated with, nor has it been authorized, sponsored, or otherwise approved by Microsoft Corporation. Don't need any special skills, save two hours every day. Here, I talk about how to turn this scroll lock on or off in Excel. It's not a keyboard shortcut, but my favourite trick is to bind the large thumb button on the rat to move window, the smaller thumb button to resize. Windows Key+T — cycle through taskbar items hit Enter to launch. Right click the status bar to make sure Scroll Lock status is enabled: The Scroll Lock setting here doesn't control Scroll Lock, it only displays Scroll Lock status. Disabling scroll lock on a Mac is just as easy—but only if you have a full-size keyboard. By the way, did you notice that the Sift key can be combined with most of the usual shortcuts. Windows Key+P — switch between display modes with a secondary display connected. First, make sure Scroll Lock is really enabled. It gets ON by pressing FN, CTRL RHS, besides arrow keys which also works as right click key and 'S' together.