- HOW TO TURN OFF SCROLL LOCK KEY HOW TO
- HOW TO TURN OFF SCROLL LOCK KEY PRO
- HOW TO TURN OFF SCROLL LOCK KEY WINDOWS 8
- HOW TO TURN OFF SCROLL LOCK KEY MAC
Recently, while reviewing customer comments related to scrolling in a spreadsheet, I discovered that a lot of folks have run into this issue. You’ve encountered that pesky little problem called Scroll Lock. You may have asked yourself, what the heck just happened, and how do I make it stop? Lucky you. Imagine you’re working in a spreadsheet and you innocently press the arrow keys on your keyboard to move to another cell, but instead of moving to another cell, the entire spreadsheet moves. She’s written and edited content for Excel, Access, OneNote, and InfoPath. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.This week’s post is written by Amy Miller. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. We will also be able to scroll up and down with the up and down arrows as well as scroll to the right and left with the right and left arrow keys. When we enable the Scroll Lock feature, we will be able to use the arrow keys in a “scrolling” manner. By default, the arrow key helps us move one cell at a time in any direction we want. We use the Excel Scroll Lock feature to help restrict or enable the use of arrow keys in Excel. Next, we will enable Extended Virtual Keyboard through which we will use this keyboard to click on F14 in the virtual keyboard.
HOW TO TURN OFF SCROLL LOCK KEY MAC
Nevertheless, not all Mac machines come with this kind of keys containing the F14 key.
HOW TO TURN OFF SCROLL LOCK KEY HOW TO
Once we can see the keyboard, we will make sure that our Excel Window is active and then we click on the ScrLk Key.įigure 6 – How to remove scroll lock in Excel How to disable Scroll Lock on a Macīy default, we can turn on the Scroll lock on Mac by using the shortcut Shift + F14. Next, we will click on Ease of Access, then Keyboard, and lastly pick the On-Screen Keyboard slider button.
HOW TO TURN OFF SCROLL LOCK KEY WINDOWS 8
If we have Windows 8 and above, we can also select Start and then Settings.Next, we will click on Ease of Access and select On-screen keyboard We can equally go to Start, select All programs and then Accessories.We can quickly access the On-screen keyboard by clicking on the Windows button and type “ on-screen keyboard” in the search box.įigure 5 – How to turn on the on-screen keyboard to activate or disable scroll lock.Here’s how to turn our virtual keyboard on and activate the Scroll lock key: If we don’t have the Scroll lock key on our keyboard, we can find it in the Virtual Keyboard. We can equally use this method to check in our Windows O.S How to disable Scroll lock in Excel on Windows If it does not change, then the Scroll Lock is on. If the name box changes with each scroll, then the Scroll lock key is turned off. However, we can also verify by trying to move the arrow keys while looking at the formula bar at the same time. We cannot find the Scroll Lock Status in the Status bar of Excel 2011 but we may find it in later Excel versions. If we find it in this session, then we know that the Scroll Lock Key is turned on. Once we have done this, we will check the base of the worksheet again. We can also right-click on the status bar to toggle it on. We may find the Scroll Lock status at the base of our worksheet as displayed above. How to check scroll lock in Excel on Windows But this feature will look different depending on your OS and version.įigure 2 – Scroll lock in excel is turned off It can be found in the same spot where we will find useful keys such as Average, page numbers, counts and sum. We can find that in the Status bar at the bottom of our Excel window. How to determine that Scroll Lock is enabledīefore we enable or disable the Scroll lock, we have to check if it is turned on. When we don’t have this toggle option, we will have to trick or gain an equivalent using the steps outlined below for both Windows and Mac.
The Scroll Lock or ScrLk key works like the CAPSLOCK, which is a key on our keyboard.
HOW TO TURN OFF SCROLL LOCK KEY PRO
In this tutorial, we will learn how to disable or enable the scroll Lock function using different ways, whether we have a MacBook, MacBook Pro or Windows Laptop.įigure 1 – How to turn off scroll lock on laptop When there is no key for Scroll Lock With the Scroll Lock Key, it becomes difficult to move from Cell to Cell. We can turn off or turn on the Excel Scroll Lock feature with or without our keyboard. How to turn off scroll lock in excel – Excelchat
0 kommentar(er)
