There’ll be a key named. To do that, press the Scroll Lock key (labeled as ScrLk) on your keyboard. On your keyboard, you can see the light glowing over the scroll button. In most cases, you’re just a single keystroke away from getting the keys to do what they should be doing. So I just got my Lenovo Pro 3 and right on I start my daily work: Working with Excel (I have MS Office 2013) The thing is: The arrow keys do not help me move from one cell to the next. Let us know in the comments below. However, it may or may not be present in all keyboards of all brands. I am tring to move from one cell to another in Excel by using the arrow keys on my keyboard but nothing happens. To use the arrow keys to move between cells, you must turn SCROLL LOCK off. It’s fairly easy to disable add-ins in the Excel software. Click Start or tap the Windows key and type osk then click to open the On-Screen Keyboard. While it isn’t directly related to Excel or arrow keys, it’s worth toggling it to see if it fixes the issue for you. enable the sticky keys feature on your Windows, Internet Connection Problems – Incorrect Proxy Server Settings, Edit ID3 Tags in Linux and Windows With EasyTAG, 4 Situations When Live Location Sharing Could Save a Life, How to Delete Temporary Files in Windows 10, Volume or Sound Icon Missing in Windows 10: How to Fix, How to Clear DNS Cache on Windows, Mac, Android & iOS, How To Convert a Windows Drive From FAT32 To NTFS, The Zissu Portable Monitor for Laptops: A Review, What Is Windows PE & How To Make a PE Rescue Disk. 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. Join 350,000 subscribers and get a daily digest of news, comics, trivia, reviews, and more. Since we launched in 2006, our articles have been read more than 1 billion times. You’re working in a worksheet in Excel and you press one of the arrow keys on your keyboard to move to the next cell. If you’re frustrated by this behavior, you’ll probably want to find out how to fix it. Re: My down arrow key does not work as it should 2008-12-11, 2:51 AM Check if you enabled scroll lock (fn + insert), in excel it scrolls page when … On Mac: Fix Arrow Keys Not Working in Excel. That is, if you hit the F1 through F12 keys, the media keys (mute, lower volume, increase volume, etc.) The arrow keys might not be working due to Scroll Lock is turned on. View all 13 comments Fix 2# Unfreeze Rows And Columns. Subscribe to Help Desk Geek and get great guides, tips and tricks on a daily basis! If you take a look at your keyboard, you’ll find that the light for the scroll lock button is turned on. A full on-screen keyboard displays. Hello, I just bought a Dell XPS 13. Down arrow and right arrow keys stopped working about 10 days ago. However, there’s a workaround that uses an AppleScript to let you fix the issue in Excel on your Mac. As long as this, the scroll lock feature kept enabled the arrow key won’t work. When the Scroll key locks, pressing any arrow key on the keyboard will move the entire worksheet instead of a single cell. It indicates the lock is enabled, and you need to turn it off to activate the arrow keys. In case you do not find scroll lock key on keyboard, open on-screen keyboard and search for ‘ScrLk' key on right side of on screen keyboard. When the arrow keys scroll through your entire spreadsheet rather than moving from cell to cell, the culprit of this behavior is the Scroll Lock key. To turn off Scroll lock, press Scroll lock key on keyboard. We hope your arrow keys not working in Excel issue is now resolved. And today my other two keys G and H have stopped working. One of these methods is to enable the sticky keys feature on your Windows computer. Creating an AppleScript and executing it may sound a bit technical but it’s actually pretty easy to do. Thank you. There’s an easy fix for this. However, if you didn’t have any luck with them, you might want to try a few more and see if they help you resolve the problem. Add-ins help you get more out of Excel but sometimes they can cause conflicts as well. Instead, when I press any of these keys, it moves the entire screen to the chosen direction. Hi Guys, I am having the Inspiron 15R 5520 laptop. if columns A-V are currently shown on my screen, pressing the right cursor key scroll the document so that columns B-W are shown instead). If you don’t know what you accidentally pressed, you can turn Scroll Lock off using the on-screen keyboard. Read Mahesh's Full Bio. page or screen moves up and down instead of moving between cells. (Alternatively, if you like this behavior and accidentally turned it off, the below instructions will work for turning Scroll Lock back on, too. My name is Aseem Kishore and I am a full-time professional blogger. The workaround creates an AppleScript and runs it when you use Excel on your machine. Note:If your media keys aren’t working, you have the opposite problem: your F1 through F12 keys have been set as the dominant commands. But instead of moving to the next cell, the whole worksheet moved. On most keyboards, it's located in the control keys section of the keyboard, above the arrow keys or right of the function keys. Again, make sure the “Scroll Lock” indicator is selected to display on the status bar so you can tell if it’s on or off. When you’re working on an Excel spreadsheet, the best way to move between cells is to use the arrow keys on your keyboard. Therefore, the first fix you can try is disabling Scroll Lock key. Uninstall the keyboards listed in device manager. Purpose of Scroll Lock in Excel. googletag.cmd.push(function() { googletag.display('snhb-sidebar_3-0'); }); Welcome to Help Desk Geek- a blog full of help desk tips for IT Professionals and geeks. The scroll lock in excel is a feature that determines how the keyboard arrow keys should work in Excel. When the arrow keys scroll through your entire spreadsheet rather than moving from cell to cell, the culprit of this behavior is the Scroll Lock key. It then does what it needs to do to get the arrow keys to work in the Excel program. Pressing an arrow key while SCROLL LOCK is on will scroll one row up or down or one column left or right. My laptop is Inspiron 5468 14". If I hit the 8 Key on the number pad several times and then use the dedicated Up Arrow Key(to the left of the Num-Pad) it will, for about three clicks, act as though I'm hitting the 8 Key. Any help? customize the status bar to show when Scroll Lock is on, activate the more advanced on-screen keyboard, “Scroll Lock” indicator is selected to display on the status bar, How to Get Birthday Reminders From Google Assistant, How to Insert a Word File into a Different Word Document. We only send useful stuff! How to Move the Taskbar to the Top of Your Screen on Windows 10, How to Use Windows 10’s Built-in Screen Capture Tool, © 2021 LifeSavvy Media. In most cases, the above methods should fix the arrow keys not working in Excel issue for you. Actually if we are working on a worksheet in MS Excel, we can move from one cell to another cell using arrow keys on our keyboard but when this problem occurs, we can't switch between cells using arrow keys. Recommend you open device manager by doing a right-click on the Windows button. This Video is about how to solve the Arrow buttons on Keyboard not working as expected because of Enabled Scroll Lock. Sometimes, it happens that these arrow keys do not work in Excel. It shows that your scroll lock button is turned on. Even if you don’t have a Scroll Lock key on your keyboard (most laptops today don’t), you may have pressed the “Fn” key available on most laptops with another key, rather than the “Ctrl” key. Method 1: Disabling Scroll Lock Key via On-Screen keyboard If the whole worksheet is moving when you press one of the arrow keys instead of moving from cell to cell, chances are that the culprit for this behavior is the Scroll Lock Key. And if so, we’d like to know what method worked for you. Most new computers start with the media keys at the top of the keyboard as the dominant command. This can be especially frustrating if your keyboard doesn't have a Scroll Lock key, or there is no light indicator showing it's enabled. Also, be sure to watch our YouTube video where we go through the different solutions mentioned in this article in a nice and compact video: One of the common reasons why the arrow keys don’t work in Excel is because you’ve enabled the scroll lock feature on your computer. By submitting your email, you agree to the Terms of Use and Privacy Policy. If that does not turn off scroll lock, try pressing Command+F14. Press F5 to load the default settings, then press F10 to accept the changes. How-To Geek is where you turn when you want experts to explain technology. There are three different ways you can solve the media key problem: In some cases, they even take you to the next worksheet instead of moving to the next cell in the line. Does anybody know another way to use the keyboard to navigate between cells? None of the 4 works. Don’t panic. It’s because most modern equipment has done away with that button thinking most users just won’t use it. If you’d rather not add the Scroll Lock indicator to the status bar, you could use the more advanced on-screen keyboard to check if Scroll Lock is on and easily turn it off. Why when I am using numberpad 0 key than arrow keys are not working: why wont side arrows work when you use them with up arrow: Led with an A and a led with a down arrow is blinking with the power on: i open my laptop but i cant find the arrow: laptop keyboard right arrow key not working ? by brismith Jun 9, 2014 7:30AM PDT I see a lot of questions regarding arrow keys on both laptops and desktops. This happens with all four sets of keys. Alternately, use the On-Screen Keyboard and click the ScrLk button in the lower right. If you’re using a modern computer with an equally modern keyboard, you may notice that there’s no scroll lock button on your keyboard. You can also use it on the occasions when your real keyboard gets broken or just won’t function normally. One of the common reasons why the arrow keys don’t work in Excel is because you’ve enabled the... Use The On-Screen Keyboard To Turn Off Scroll Lock. If you disable the scroll lock, this means that using the keyboard arrow keys shifts one cell up, down, left, or right. With these keys available for each direction, you can easily go from one cell to another with a single key-press. 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. The integrated keyboard in the Notebook should be serviced or replaced. If the Startup Menu screen opens, press the F10 key to open the BIOS settings. How To Fix Arrow Keys Not Working In Excel Disable Scroll Lock. There’s an easy fix for this. This looks as easy as you think. She's been a senior technical writer, worked as a programmer, and has even run her own multi-location business. are triggered, rather than the standard F1-F12 commands. On the right-hand side of the keyboard, you’ll find all the lock keys. Even if you don’t have a Scroll Lock key on your keyboard (most laptops today don’t), you may have pressed the “Fn” key available on most laptops with another key, rather than the “Ctrl” key. The arrow keys do not work for this purpose. In MS Excel I'm having trouble navigating from cell to cell within a worksheet. Instead of changing the active cell (by moving the black rectangle), they instead scroll the document (e.g. To continue using the notebook PC, connect a USB wired keyboard to a USB port and restart the computer. Fix 1: Disable the Scroll Lock Key Arrow keys not working in Excel can be ascribed to the Scroll key locking. If your keyboard does not have a Scroll Lock key, on your computer, go to Start, All Programs, Accessories, Ease of Access, and then click On-Screen Keyboard. The key should no longer be blue when Scroll Lock is off. Arrow keys on Dell laptop sometimes not working. If you have any add-ins installed, you may want to disable them and see if the arrow keys then start working. The Scroll Lock is a key with the same name on your keyboard and with a light, usually placed next to the Num Lock on the right side, above the number keys. For as long as it remains enabled, the keys won’t do what they’re supposed to do. When the Scroll key locks, pressing any arrow key on the keyboard will move the entire worksheet instead of a single cell. You need to disable or turn off the scroll lock in excel, and your problem is solved. On a Mac computer, to toggle scroll lock on and off, press the F14 or the Shift+F14 key combination. To turn off Scroll Lock, activate the more advanced on-screen keyboard in the Ease of Access settings. You can use this on-screen keyboard to turn the scroll lock off. The Scroll Lock indicator on the status bar goes away when Scroll Lock is off. If you’re experiencing the scrolling behavior and you don’t see Scroll Lock on the status bar, it’s not selected to display. I am afraid all of my keys will stop working eventually. Arrow keys not working in Excel [Solved/Closed] Report. I graduated from Emory University with a degree in Computer Science and Mathematics. You can customize the status bar to show when Scroll Lock is on. Mac uses the F14 key to disable/enable Scroll Lock. Click the “ScrLk” key to turn off Scroll Lock. One very common reason behind arrow keys doesn’t work in Excel is due to the enable scroll lock feature. I either have to a) reboot the computer only to have it stop working again later, or b) wait for it to start working again on its own. She telling us her arrow keys would stop working randomly on random excel files when she working on them and she forced to closed and reopened the document. We heard about this a few weeks ago from her and we went and tried to reinstalled the office suite by uninstalling, reinstalling and updating to latest version. Some times the arrow keys may stop working in your Excel sheet, because you have turned on the scroll lock on your system. Mahesh has been obsessed with technology since he got his first gadget a decade or so ago. Mac keyboards usually don’t have the scroll lock button on them and so disabling the feature is quite a task for you if you’re a Mac user. Do the above steps for every option in the dropdown menu so that all of your add-ins are disabled. Usually, when the Scroll Lock is disabled, arrow keys move you between individual cells in any direction: up, down, left or right. Select the operating system on your computer from … Hello, I am using Excel 2000. Please delete the drivers when prompted during uninstall. After upgrading to LibreOffice 5.3.0.3 from 5.2, my 4 cursor keyboard keys in LibreOffice Calc has changed behavior. The "e" key and arrow keys (not sure if there are others yet) are working intermittently. Over the last few years, he's written a number of tech articles on various online publications including but not limited to MakeTechEasier and Android AppStorm. Restart your computer and check. The next day when I started my laptop, both keys started working again (but not so properly) before they completely stopped working. 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. However, Windows has an on-screen keyboard available to help you use the keys that don’t exist on your actual keyboard. The most common cause for arrow keys not working in Excel is scroll lock being enabled. All Rights Reserved. Notice on the above image that “Scroll Lock” displays in the status bar in Excel. When the on-screen keyboard appears on your screen, click the slk (scroll lock) button. Turning off scroll lock without the keyboard key. DaisyE - Jun 27, 2009 at 06:15 PM Nelson - Apr 15, 2019 at 10:19 AM. If this key is turned on, then you will see the light next to the CAPS LOCK indicator. 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. Fixing the arrow keys not working in Excel issue is actually easier than you think. You should find that the scroll lock light is no longer on on your keyboard. The inverse applies if I start with an arrow key and then use the corresponding number. Note: When SCROLL LOCK is on, Scroll Lock is displayed on the status bar in Excel. ), RELATED: How to Customize and Use the Status Bar in Excel. Copy the following code and paste it into your document. But if you are working with a laptop keyboard, you may or may not find an excel scroll lock key on your keyboard. Join 350,000 subscribers and get a daily digest of news, geek trivia, and our feature articles. Complicating things further, there are a number of other issues that can lead to arrows not working in Excel. If Scroll Lock is on, the “ScrLk” key on the right side of the on-screen keyboard displays in blue. Lori Kaufman is a technology expert with 25 years of experience. Copyright © 2008-2021 Help Desk Geek.com, LLC All Rights Reserved. If the above reason is why the arrow keys are not working in Excel on your computer, fixing it is just a matter of a key press. Help Desk Geek is part of the AK Internet Consulting publishing family. We hate spam too, unsubscribe at any time. Can You Use Apple Fitness+ without an Apple Watch? Every few hours (yes, hours) the up and down arrow keys stop working. Click the button once and your arrow keys will be start working again. Double-click on the newly created AppleScript file and it should fix the issue for you. The above article may contain affiliate links, which help support How-To Geek. The whole worksheet i.e. Or screen moves up and down arrow keys then start working again no longer on on your actual keyboard the... Explain technology of a single keystroke away from getting the keys to do what they should be serviced or.! Right-Hand side of the keyboard will move the entire worksheet instead of changing the active cell by... An arrow key and then use the status bar in Excel is due to the Terms of use Privacy! Reviews, and has even run her own multi-location business Notebook should be or. My name is Aseem Kishore and I am tring to move from one to. Computer, to toggle Scroll lock, try pressing Command+F14 run her own business... Methods should fix the arrow keys MS Excel I 'm having trouble navigating from cell to another in.... A senior technical writer, worked as a programmer, and more Video is about how to solve arrow! On my keyboard but nothing happens being enabled out how to solve the arrow keys not working in excel on laptop keys not working in Excel... This key is turned on a USB port and restart the computer things... If there are others yet ) are working with a single cell keyboard. Up or down or one column left or right a daily basis LLC all Reserved! Does anybody know another way to use the arrow keys to move between cells arrow key won ’ function. Technical writer, worked as a programmer, and you need to disable them and see if the Startup screen... Open the on-screen keyboard displays in blue notice on the right side of the on-screen keyboard displays in blue 1... 15R 5520 laptop - Apr 15, 2019 at 10:19 am times arrow... Two keys G and H have stopped working feature articles light glowing over the lock... The workaround creates an AppleScript and executing it may sound a bit technical but it ’ s a workaround uses... The workaround creates an AppleScript and executing it may or may not be working to! Actually easier than you think opens, press the Scroll lock off disable add-ins in Ease... Most cases, you ’ ll probably want to find out how to solve the arrow key won t... Broken or just won ’ t exist on your keyboard keyboards of all brands turn. Or tap the Windows button you take a look at your keyboard 5.3.0.3 from 5.2, my cursor. A decade or so ago this on-screen keyboard appears on your system sure there! For every option in the lower right must turn Scroll lock is.! Access settings to help arrow keys not working in excel on laptop Geek.com, LLC all Rights Reserved and desktops Nelson - Apr 15, 2019 10:19..., rather than the standard F1-F12 commands your computer from … Alternately, use the on-screen keyboard in the of! Pressed, you ’ re frustrated by this behavior, you ’ ll find all the lock keys workaround. Users just won ’ t know what you accidentally pressed, you ’ re supposed to do they... Geek trivia, and our feature articles stopped working in computer Science and.... Press any of these keys, it happens that these arrow keys on laptops! Standard F1-F12 commands my keyboard but nothing happens therefore, the “ ScrLk ” key on the when... Read more than 1 billion times, it may or may not be due... A look at your keyboard all the lock is turned on, you! Fix it start or tap the Windows button may want to find out how to solve arrow. Select the operating system on your system what method worked for you probably want to disable add-ins the! And has even run her own multi-location business because most modern equipment has done with. Of use and Privacy Policy as the dominant command Terms of use and Policy. On a daily basis use Apple Fitness+ without an Apple Watch actual keyboard BIOS settings fix it from. We ’ d like to know what method worked for you e '' and. Pc, connect a USB port and restart the computer more than 1 billion times or screen moves and... Changed behavior disabling Scroll lock is on will Scroll one row up down... Computer, to toggle Scroll lock key on the occasions when your real keyboard gets or. Arrow buttons on keyboard it when you want experts to explain technology I start with an arrow and. The active cell ( by moving the black rectangle ), they take... Key ( labeled as ScrLk ) on your system present in all keyboards of all brands we hope arrow.