Here you can easily know about How To Turn Off Scroll Lock In Excel. Microsoft Excel is a helpful and powerful program for data analysis and documentation.
It is a spreadsheet program, which contains a number of columns and rows, where each intersection of a column and a row is a “cell.” Each cell contains one point of data or one piece of information. By organizing the information in this way, you can make information easier to find, and automatically draw information from changing data.
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.
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 to 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. You can do this by working with the status bar, 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, Scroll Lock is probably turned on.
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.
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 Scroll Lock 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.
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 to 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).
Virtual Keyboard, a commercial freeware utility by Coral lo Software (14 day trial) seems to work.