nomadfix.blogg.se

1. #Turn off scroll lock in excel how to
2. #Turn off scroll lock in excel pro
3. #Turn off scroll lock in excel windows 8
4. #Turn off scroll lock in excel mac

Turn on/off scroll lock by press Scroll Lock button on the keyboard

#Turn off scroll lock in excel how to

Here, I talk about how to turn this scroll lock on or off in Excel. Sometimes, this is quite annoying, and you want to turn it on.

In Excel, when you press Up and Down arrows or Left and Right arrows incautiously, the active cell moves at the same time. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.How to turn on/off the scroll lock in Excel? 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.

#Turn off scroll lock in excel mac

Nevertheless, not all Mac machines come with this kind of keys containing the F14 key. 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.

#Turn off scroll lock in excel 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.

#Turn off scroll lock in excel 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