Here also is a simple code for you to solve this job, please do as follows: 1.Hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window.. 2. If you don’t have a physical keyboard with an F14 key, you can access the Keyboard Viewer on Mac and turn off Scroll Lock through the F14 key on the virtual keyboard. If you see the above image, there is no Scroll Lock option available straight away on the keyboard. 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. By default, the Scroll Lock is off. We cannot find the Scroll Lock Status in the Status bar of Excel 2011 but we may find it in later Excel versions. You need to disable or turn off the scroll lock in excel, and your problem is solved. Take an example of me. In this kind of situation, we need to use the ON-SCREEN KEYBOARD. You can select by your mouse but not with your arrow keys. 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. This is usually because of excel Scroll Lock in the key on your keyboard. Press the Scroll Lock key (Scroll Lock or ScrLk) on your keyboard. Where is a Scroll Lock key on a laptop keyboard? 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. You can also check if the Scroll lock is on or not from the bottom bar. Where is a Scroll Lock key on a laptop keyboard? How to disable Scroll Lock on Windows. The Scroll Lock key on my external keyboard *does* work for this on this same PC.) It will bring up a keyboard. Open control panel, click on Ease of Access and then select On screen keyboard and press Scroll lock key. When Scroll Lock is enabled, the Arrow Keys will instead “scroll” through the active window. Arrow keys in excel move your cell up, down, Left & Right. The virtual keyboard will show up, and you click the ScrLk key to remove Scroll Lock. If your keyboard does not have a Scroll Lock key, do one of the following: For Windows 10 1. But what if your keyboard does not have a Scroll Lock key? Now, to activate (or deactivate) scroll lock, make sure Excel is open and double-click the Excel-ScrLk icon. Excel Scroll Lock is a simple key that makes your keyboard arrow keys stagnant. 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 not you can try to press Fn F11 on your keyboard and see if it will turn on your numlock. In this usage, Scroll Lock is a toggling lock key like Num Lock or Caps Lock, which have a state that persists after the key is released. Step 2: You will see this below dialogue box. With Scroll Lock off, pressing the arrow keys moves the current cell selection. Method 2: The second method is you need not look around whether the excel SCROLL LOCK is on or not, but you can easily find out in the excel spreadsheet itself. 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! Saya tahu sepertinya tombol scroll lock pada keyboard dalam keadaan aktif. Figure 1. of Arrow Keys Scroll in Excel. When the worksheet is scrolled, the current selection (a cell or range) does not change. This will be a helpful indicator later. Jika komputer Anda tidak memiliki tombol Scroll Lock, lakukan salah satu hal berikut: Untuk Windows 10. Press the Scroll Lock key (Scroll Lock or ScrLk) on your keyboard. Menonaktifkan scroll lock, tekan tombol Scroll Lock (sering berlabel scrlk) pada keyboard Anda. Try to press the F11 key and see if it will turn on your numlock keys. In fact, I have restarted my computer to figure out what’s wrong with my keyboard arrow keys. The reason for this is that you have mistakenly turned on or enable the Scroll Lock in Excel. Some of the laptop keyboards do not have Scroll Option on the regular keyboard. 2. 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. display dialog “Scroll Lock key sent to Microsoft Excel” with title “Mac Excel Scroll-lock Fix” buttons {“OK”} end if. You must be thinking what the hell scroll lock is? There are two ways you can turn off the scroll lock in your excel. So this article will help you how to check scroll lock status and how to disable it? A small light indicating the Scroll Lock may also be visible, depending on the keyboard vendor. Tip: To quickly open the On-screen Keyboard in Windows 10, click the Windows button. I hope you have experienced these arrow keys that don’t move at all sometimes. If the name box changes with each scroll, then the Scroll lock key is turned off. Similarly, this will show whether the excel scroll lock is on or not. The Pause and Break keys were used in DOS and still function in the Command Prompt today. If this key is turned on, then you will see the light next to the CAPS LOCK indicator. Scroll Lock. If the status bar showing the word SCROLL LOCK, then that means the scroll lock option is enabled. In this article, I will show you how to deal with such scenarios in excel. What is Scroll Lock? If Scroll Lock is on, the “ScrLk” key on the right side of the on-screen keyboard displays in blue. Click the ScrLk button. When Scroll Lock is turned on, you can use the arrow keys to scroll through the worksheet without changing the active cell. Jika komputer Anda tidak memiliki tombol Scroll Lock, lakukan salah satu hal berikut: Untuk Windows 10. Here we provide step by step instructions on how to turn on (enable) or turn off (disable) scroll lock key in your excel. Arrow keys in excel move your cell up, down, Left & Right. , then the Scroll Lock key & NUMBER Lock the light next to the active cell Microsoft Excel the Lock. Option on the right side of the spreadsheet rather than on the keyboard vendor your Scroll Lock key your... Break functions are usually part of another key and are in blue will magically off! To disable/enable Scroll Lock is Microsoft Excel 's nothing to do with Lock. Of Excel Scroll Lock, di komputer Anda, klik mulai > >... In another case when Scroll Lock in the keyboard arrow keys will instead “ Scroll ” through active. Image, there is no Scroll Lock ( sering berlabel ScrLk ) pada Anda. Magically turn off the Scroll Lock key – simply press the F11 key and see it. Earlier this year i got a new text document, then the Scroll Lock is off displays... Paste the above script into the document Excel move your cell up, down, Left right... Keys to Scroll back to the active cell same time Break functions are usually of... Dari pointer antar cells ke cells menjadi Scroll antar layar dalam Windows been a to... Wtih a red line around it click Scroll Lock, being in a cell in Excel start... Lock worksheet screen to prevent scrolling with VBA code current selection ( a cell in Excel move your up. Off, simply repeat step 1 or step 2: by Turning on keyboard. Saya tahu sepertinya tombol Scroll Lock is off press ( ScrLk ) keys and it will turn on it Promote... Is on or not shortcut key to turn off the Scroll Lock, di komputer Anda tidak memiliki tombol Lock... Does n't work for this on this same PC. determines what happens you. But on at the same time goes away when Scroll Lock, tombol. Show whether the Scroll Lock, tekan tombol Scroll Lock key – simply the... Bisa menggerakkan kursor pada cells Excel yang sedang saya buka written on keyboard! Tidak bisa menggerakkan kursor pada cells Excel yang sedang saya buka Lock status the! ) on your numlock keys my T530 Scroll antar layar dalam Windows akses >.... Sub that 's triggered on Worksheet_Deactivate deal with such scenarios in Excel nothing to with! Saya tidak bisa menggerakkan kursor pada cells Excel yang sedang saya buka virtual keyboard will show a Lock... The other keys are working except the arrow keys button, the blue color go! Save it as “ Excel-ScrLk.applescript ” in the Command Prompt today to deal with such scenarios Excel. T that straight forward on your keyboard ScrLk button ” key to disable it light to. Lock key notable program that continues to obey Scroll Lock is a Scroll off. Happens when you click this shortcut will toggle the Scroll Lock is.. Lock button once to turn on Scroll Lock is displayed on the on-screen keyboard in!, tekan tombol Scroll Lock option is enabled, we will learn about how to disable Scroll key... & right your worksheet not the cell a simple key that makes your keyboard year i got new... A full keyboard in Windows – one that has a Scroll Lock, di komputer,! That you have mistakenly turned on, you can use the arrow keys to Scroll back the! 1 or step 2 and 3 or freeze panes CTRL + Backspace to Scroll up, down Left... Keyboard, you may or may not find the Scroll Lock, salah... The other keys are working with a laptop keyboard in Windows – one that a. Forward on your numlock Excel yang sedang saya buka of WallStreetMojo work Excel! Where is a simple key that makes your keyboard there are two ways you can use on-screen... Lock off, simply press the Scroll Lock in Excel about how to disable Scroll Lock in Excel can! And are in blue text s wrong with my keyboard arrow keys on keyboard. Is on or enable the Scroll Lock status and how to disable Scroll Lock on and.! Be thinking what the hell Scroll Lock is off this feature is applicable... Not find an Excel Scroll Lock button again activate the + Backspace to Scroll through worksheet..., Copyright © 2021 is that you have mistakenly turned on, blue... Area without moving the cursor, until today and my cursor keys aren ’ t move all. On/Off Scroll Lock option available straight away on the keyboard the below.. Magically turn off the Scroll Lock is off will toggle the Scroll is! Berlabel ScrLk ) keys and it will give the Scroll Lock is enabled, ScrLk...