When Scroll Lock is enabled, the Arrow Keys will instead “scroll” through the active window. You can select by your mouse but not with your arrow keys. Now come back to MS Excel. When Scroll Lock is turned on, Excel displays Scroll Lock in the status bar (only if the status bar is customized to display the Scroll Lock status). If there is no Scroll Lock key in your keyboard, you can use this this method. If it does not change, then the Scroll Lock is on. Method 1: The moment you experience the situation of arrow keys not moving in your excel spreadsheet, then you need to check the arrow key option. If your status bar does not show this, then your SCROLL LOCK is not turned on. If Scroll Lock is on, the “ScrLk” key on the right side of the on-screen keyboard displays in blue. Go to Download Free Trial 30 days Purchase PayPal / MyCommerce. Jika komputer Anda tidak memiliki tombol Scroll Lock, lakukan salah satu hal berikut: Untuk Windows 10. Open a new text document, then copy and paste the above script into the document. Scroll Lock. However, we can also verify by trying to move the arrow keys while looking at the formula bar at the same time. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy, New Year Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More, You can download this Scroll Lock Excel Template here –, All in One Excel VBA Bundle (35 Courses with Projects), 35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion. In this article, I will show you how to deal with such situations, how to turn on or turn off the scroll lock key in your computer and, most importantly, how to turn on and turn off the scroll lock key in your laptop. Click the Windows button and start typing “on-screen keyboard” in the search box. Scroll Lock in Excel is used to scroll up, down, left & right your worksheet not the cell. In this kind of situation, we need to use the ON-SCREEN KEYBOARD. Go to Start and type OSK for onscreen computer. You need to disable or turn off the scroll lock in excel, and your problem is solved. Note: the Scroll Lock status message may or may not be visible on the left side of the status bar, since it can be disabled. On other Mac laptops or smaller keyboards, you'll need to install a virtual keyboard app that includes the F14 key in order to disable scroll lock in Excel. If the name box changes with each scroll, then the Scroll lock key is turned off. You may learn more about excel from the following articles –, Copyright © 2021. Where is a Scroll Lock key on a laptop keyboard? When the scroll lock feature is turned on, pressing an arrow key causes Microsoft Excel to move the entire spreadsheet, instead of moving to the next cell.Although helpful for a user viewing a large worksheet, it's also quite annoying for those who have mistakenly enabled this feature. Done. In this article, we will learn about how to disable Scroll Lock in Excel. Yes, I have experienced it as well. How to use Arrow Keys in Excel. 3. The Fn + C key combination doesn't work for me on my T530. I contacted support and got it fixed. Turning Off Scroll Lock is an easy-peasy job. Scroll lock in excel occurs when we press the scroll lock button in our keyboard or from the virtual keyboard, normally when we press the down arrow key from any cells it takes us to the next cell below it but when we have scroll lock on it drags the worksheet down while the cursor remains on the same cell, to disable scroll lock we can turn it off from the keyboard or from the virtual keyboard. Formula Entry mode is when you select a cell in Excel, type = and then start typing a function. Click the On-Screen Keyboard app to run it. How to determine that Scroll Lock is enabled. Note: press CTRL + Backspace to scroll back to the active cell. Arrow keys in excel move your cell up, down, Left & Right. Done. If your keyboard does not have a Scroll Lock key, launch the on-screen keyboard. | Turn off Scroll Lock. But what if your keyboard does not have a Scroll Lock key? In excel, in order to move fast from one cell to another, select a range of cells, go to the end of the last used cell in the worksheet, and many other things require keyboards arrow keys. The Pause and Break keys were used in DOS and still function in the Command Prompt today. Tip: To quickly open the On-screen Keyboard in Windows 10, click the Windows button. display dialog “Scroll Lock key sent to Microsoft Excel” with title “Mac Excel Scroll-lock Fix” buttons {“OK”} end if. .free_excel_div{background:#d9d9d9;font-size:16px;border-radius:7px;position:relative;margin:30px;padding:25px 25px 25px 45px}.free_excel_div:before{content:"";background:url(https://www.wallstreetmojo.com/assets/excel_icon.png) center center no-repeat #207245;width:70px;height:70px;position:absolute;top:50%;margin-top:-35px;left:-35px;border:5px solid #fff;border-radius:50%}. Step 2: You will see this below dialogue box. After so many days, I came to know that the problem is not with the arrow keys but with the SCROLL LOCK option on the keyboard. When Scroll Lock is enabled in Excel, pressing the arrow keys will scroll the viewing area without moving the cursor. 6/9 Completed! Try to press the F11 key and see if it will turn on your numlock keys. The solution is simple. So, earlier this year I got a new Logitect EX110 wireless keyboard. On Mac: Fix Arrow Keys Not Working in Excel. Today, this particular use of Scroll Lock is rare. If you want to turn scroll lock off, just need to press the Scroll Lock button again. If your keyboard does not have a Scroll Lock key, do one of the following: For Windows 10 1. Click the “ScrLk” key to turn off Scroll Lock. Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days. However, when the Scroll Lock is enabled in Excel, arrow keys scroll the worksheet area: one row up and down or one column to the left or right. You need to use a different technique only. I have a VBA sub that's triggered on Worksheet_Deactivate. One of the common reasons why the arrow keys don’t work in Excel is because … Go to Next Chapter: Print, Scroll Lock • © 2010-2021 Save it as “Excel-ScrLk.applescript” in your Applications folder. 23 May 2018. To turn it off, simply press the Scroll Lock key on your keyboard. You must be thinking what the hell scroll lock is? Jika keyboard Anda tidak memiliki tombol Scroll Lock, di komputer Anda, klik mulai > pengaturan > Kemudahan akses > Keyboard. Right click a blank area of the Status Bar at the bottom of the Excel application window and ensure that the Scroll Lock indicator is checked. In order to activate the On-Screen key Board (OSK), follow the below steps. This shortcut will toggle the scroll lock on and off in Excel. So this article will help you how to check scroll lock status and how to disable it? CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. On a laptop, the ScrLk, Pause, and Break functions are usually part of another key and are in blue text. Right click the status bar to display or to hide the Scroll Lock status. See How to disable Scroll Lock for for a full run-down on how to turn off scroll lock if you don't have an extended keyboard. Click Start > Settings > Ease of Access > Keyboard > Use the On-Screen Keyboard (or press the Windows logo key + CTRL + O). 2. Which function key is Scroll Lock? Login details for this Free course will be emailed to you, This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. If your keyboard does not have a Scroll Lock key, on your computer, click Start > Settings > Ease of Access > Keyboard. This has been a guide to Scroll Lock in Excel. I have closed the workbook. If the scroll lock is switched on by accidentally, then you must have spent so many minutes to figure out why your arrow keys are not functioning to move easily in the worksheet. If the scroll lock is open, it will show you scroll lock written on the bottom bar. Saya pernah mengalami kejadian dimana saya tidak bisa menggerakkan kursor pada cells Excel yang sedang saya buka. This will be a helpful indicator later. There are two ways you can turn off the scroll lock in your excel. This shortcut toggles Scroll Lock on and off. Note: to turn on scroll lock, simply repeat step 1 or step 2 and 3. This is usually because of excel Scroll Lock in the key on your keyboard. You need to press this button with your mouse key to turn off. I have spent a considerable amount of time figuring out this issue. Learn how to turn off scroll lock in Excel Don't forget to check out our site http://howtech.tv/ for more free how-to videos! Usually, we see the cells changing with the arrow key movement, but if the scroll lock is turned on and you do not know this, then you will be frustrated to find out the issue with your keyboard. Lock worksheet screen to prevent scrolling with VBA code. The Scroll Lock key on a laptop is often a secondary function of another key, located near the Backspace key.If a laptop is using two keys as one key, you must press the Fn key with the second key you want to use. turning off SCROLL LOCK isn’t that straight forward on your laptop. The key should no longer be blue when Scroll Lock is off. Excel Scroll Lock is a simple key that makes your keyboard arrow keys stagnant. To turn off scroll lock, execute the following step(s). You can also try to look on your F1-F12 keys if you can see a lock symbol or something that indicates to a numlock, then press Fn that key. Step 4: You can notice the ScrLk key is turned on with a blue-colored key indication. Now, to activate (or deactivate) scroll lock, make sure Excel is open and double-click the Excel-ScrLk icon. The Scroll Lock indicator on the status bar goes away when Scroll Lock is off. Take an example of me. After looking for the dang key for 20 minutes! It has one main use that's stuck around, though: it changes how the arrow keys function in Excel. If you have Kutools for Excel, with its Set Scroll Area utility, you can quickly lock and hide other direction beyond the selected range with only one click. Re: Where is the Scroll Lock key on Inspiron15? Click Start > Settings > Ease of Access > Keyboard > Use the On-Screen Keyboard (or press the Windows logo key + CTRL + O).