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. In the example picture, Scroll Lock is actually part of the , so you would need to press the Fn key and the Num Lk key to execute the Scroll Lock functionality. Now Scroll lock is disabled from excel sheet. In the opening folder, click the Control Pane Home in the left. You'll know that Scroll Lock is disabled when the ScrLk key returns to dark-grey.
Tip: To quickly open the On-screen Keyboard in Windows 10, click the Windows button. Somehow Excel 2010 got the Scroll Lock on. To emulate this key, simply press Fn+K or Fn+C depending on your laptop model. If you suspect that Scroll Lock is turned on, but Scroll Lock does not appear in the Excel status bar, it may be because the status bar is customized to hide the Scroll Lock status. About the Author Chris Daniels covers advances in nutrition and fitness online.
Last week upgraded to Windows 7 from Vista - navigating with arrow keys worked perfectly with Vista. 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. Then the On-Screen Keyboard appears on the screen, and just click the ScrLk button. Right click any blank place on the screen in the Windows 8, and click the Personalize from the context menu. To determine if this is the case, right-click the Excel status bar. I have a notebook with no Scroll Lock key or any shortcut using the 'Fn' key. Look for that symbol if not on the F12 key.
Scroll Lock in Excel for Mac Unlike Excel for Windows, Excel for Mac does not show Scroll Lock in the status bar. 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. Try moving around with the arrow keys and watch the address in the name box directly left of the formula bar. Here, Office Tab supports similar processing, which allow you to browse multiple Excel workbooks or Word documents in one Excel window or Word window, and easily switch between them by clicking their tabs. Please delete the drivers when prompted during uninstall.
But instead of moving to the next cell, the whole worksheet moved. Windows - Turn off the Scroll Lock feature by pressing the Shift- Scroll Lock ScrLk keys. If the address does not change and the arrow key scrolls the whole worksheet, it's safe to assume that Scroll Lock is enabled. The only way I know to verify the Scroll Lock state is to use the arrow keys and observe behavior. Open the Excel, and then press Scroll Lock button on the keyboard to turn on it.
Your report is due in an hour. 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. This works on my 2015 Macbook Pro reliably to turn Scroll Lock on and off. Note: To close the on-screen keyboard, click the X in the upper-right corner of the on-screen keyboard. But what if your keyboard does not have a Scroll Lock key? I'm new to the forums so if I did anything wrong please tell me. Here, I talk about how to turn this scroll lock on or off in Excel. The picture shows what a Scroll Lock key with an may look like on a keyboard.
To determine if it's the case, right click the status bar and see if there is a tick mark to the left of Scroll Lock. If the issue persists, run a keyboard test by booting the computer system diagnostics. Addendum: Right-click Excel's bottom status bar and put a check beside Scroll Lock to get a scroll lock indicator on the left side of the status bar. Sometimes, this is quite annoying, and you want to turn it on. Not the answer you're looking for? How to determine that Scroll Lock is enabled To see whether the Scroll Lock is turned on, just look at the status bar at the bottom of the Excel window.
Step-by-Step Macintosh - Turn off the Scroll Lock feature by pressing the Shift- F14 keys. Click the ScrLk button on the popping up On-Screen Keyboard. To close the on-screen keyboard, click the X button in the upper-right corner. Note Smaller, more compact laptops may not include a Scroll Lock key. 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.
The rest of this article explains how to do that on both Mac and Windows. If you see a small bar with a few keys, click General. Where is a Scroll Lock key on a laptop keyboard? Mac Excel 2011 doesn't show scroll lock status anywhere. I haven't checked Excel 2016 yet. If Scroll Lock status is not enabled in the status bar, it might be toggled on and you'll never see it. It may be necessary to press the function lock key to enable or disable Scroll Lock if two function are indicated on the key.
On my Toshiba and previous one that I had I hold the Fn key and press F12 to toggle between scroll lock on and off. Case Study 2: For Windows 8. If F14 exists on your keyboard, but there is no Fn key, use the Shift + F14 shortcut to toggle the Scroll Lock on or off. When Scroll Lock is off It is a default setting , the Arrow Keys allow you to navigate and select different cells within a worksheet. Browse other questions tagged or. If it is blue, Scroll Lock is still on.