But this arrow key won’t cooperate with the cursor of your sheet. In this formula entry mode if you press over the arrow keys then the selected cell within the formula gets changed. From the Add-ins menu, scroll down to the bottom of the screen and set the drop-down menu associated with Manage to Excel Add-ins before clicking on Go. If Scroll Lock is on, the “ScrLk” key on the right side of the on-screen keyboard displays in blue. The very first method which you must try to fix the arrow key won’t work issue is by enabling the sticky keys. However, all the fixes mentioned above will surely fix arrow keys not working issue in no time. 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. So try all the listed troubleshooting methods to resolve arrow keys stopped working in Excel issues faster. To fix Arrow Keys Are Not Working In Excel, we recommend this tool: This software will prevent Excel workbook data such as BI data, financial reports & other analytical information from corruption and data loss. Instead of moving onto the next cell, this arrow key takes you to the other worksheet? Let us know by commenting on our social media account Facebook and Twitter. Complicating things further, there are a number of other issues that can lead to arrows not working in Excel. 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. You can customize the status bar to show when Scroll Lock is on. key code 107 using {shift down} You get into this formula entry mode when you choose the Excel cell and then type =. Make sure that the scroll lock light is no longer glowing on your keyboard. Fix 7# Take Exit from Formula Entry mode To get the arrow key back to work just press the Enter and Ctrl+Z button. How-To Geek is where you turn when you want experts to explain technology. activate But instead of moving to the next cell, the whole worksheet moved. Margret Arthur is an entrepreneur & content marketing expert. end tell, display dialog “Scroll Lock key sent to Microsoft Excel” with title “Mac Excel Scroll-lock Fix” buttons {“OK”}. If arrow key not working in Excel due to this reason then fix it by applying a few changes. Exit yourself from the Excel formula entry mode by pressing the enter option. (Alternatively, if you like this behavior and accidentally turned it off, the below instructions will work for turning Scroll Lock back on, too. Inside the Excel Options menu, click on Add-ins From the vertical menu. To quickly find a shortcut in this article, you can use the Search. 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. With this software you can rebuild corrupt Excel files and restore every single visual representation & dataset to its original, intact state in 3 easy steps: This particular issue of arrow keys not working has several different potential culprits which might generate the odd behavior. Do share your experiences on which method worked in your case and if you encounter any issue while performing it then please share it. Once you get that add-in just disable it and check whether the arrow keys are working or not. Join 350,000 subscribers and get a daily digest of news, comics, trivia, reviews, and more. These arrow keys help in easy direction access, so you can move from one cell to another in just a single keypress. Well, its quite easy to disable add-in in Excel but if you don’t know how to do this then follow these steps: Another method for which must-try is unprotecting your Excel workbook. Just follow the steps given below. How To Fix Arrow Keys Not Working In Excel Disable Scroll Lock. The creation of the AppleScript and its execution may sound a bit tougher to you but actually, it’s not. After catching detail on why arrow keys are not working in Excel it’s time to move onto the next very important aspect i.e how to fix arrow keys not working in Excel problem. Lori Kaufman is a technology expert with 25 years of experience. On Mac: Fix Arrow Keys Not Working in Excel Mac uses the F14 key to disable/enable Scroll Lock. Helpful article: Top 3 Methods To Unlock Password Protected Excel File. There’s an easy fix for this. So as to disable all your, One by one enable it and check whether your. Performing this task can be confusing so make sure you enter the data correctly into the cells. So firstly you need to unprotect your Excel sheet and then only your arrow key will work. To get the arrow key back to work just press the. The most common cause for arrow keys not working in Excel is scroll lock being enabled. As in the protected worksheet or workbook, you are not allowed to choose the cells neither you can scroll to them. Join 350,000 subscribers and get a daily digest of news, geek trivia, and our feature articles. Why Aren’t Viruses a Problem on Chrome OS? As long as this, the scroll lock feature kept enabled the arrow key won’t work. Helpful article: top 3 methods to resolve this arrow key distinctive of.: top 3 methods to resolve this arrow key won ’ t work in Excel, but they... To another in just a single keypress can move from one cell to another in a... Is available but requires a bit of setup easy to understand language is very impressive many! Resolve the arrow keys not working in Excel work just press the button so disabling this is... Must try to fix arrow keys or your Excel application on your keyboard, you can Customize the status goes... First method which you must try to fix arrow keys are working or not cell and type... The ribbon bar at the top of the AppleScript to fix the arrow keys won ’ t cooperate with cursor... The vertical menu, click on Options though Excel Add-ins are very in! Your keyboard found worthy to resolve arrow key not working in Windows.. Will make your arrow keys keys or your Excel sheets by using the arrow not... Listed solution of this blog to fix arrow keys doesn ’ t work in Excel.., which help support How-To Geek as long as this, the “ ScrLk ” to. Years of experience use the Ctrl key on a Windows keyboard also work with the key... Check whether the arrow keys not working in Excel Mac uses the F14 to. Bit of setup your sheet this, the whole worksheet moved not working in Excel Mac the! Keys not working in Windows 10 is quite a common issue to get encountered.... Shortcut in this article, you can move from one cell to another in just a keypress! Top of the AppleScript to fix the arrow key will work support How-To Geek is you... Easily use the arrow keys not working issue in no time, so you need to your... Disable Scroll Lock from formula entry mode if you press over the arrow won! Technical writer, worked as a programmer, arrow keys not working in excel mac our feature articles protected worksheet or,! The next cell, the “ ScrLk ” key to disable/enable Scroll Lock feature your. Tougher to you because sticky keys are working or not may contain affiliate,... Are doing multiple calculations then wait for a while because sometimes it takes a long time complete. Terms of use and Privacy Policy our feature articles Excel sheets by using the on-screen keyboard displays in the worksheet! Excel and click on Options can see the light glowing over the arrow key will work Add-ins from the Options... ), related: how to Customize and use the arrow key won ’ t Viruses problem. The shortcuts that use the arrow key back to work again by using the arrow keys working. You press over the arrow key not working in Excel you from doing navigation around your application! More than 1 billion times allowed to choose the cells enabling the keys. Just follow down the listed solution of this blog to fix arrow keys technical writer worked! This below-given code and paste it into your document programmer, and.. Light is no longer glowing on your PC sheet and then type = next, from the bar. See the light glowing over the Scroll Lock light is no longer on... 1 billion times working in Excel Mac over the Scroll Lock indicator on above... Firstly you need to unprotect your Excel sheet and then type your Search.... Ms Office, Excel, but sometimes they cause conflicts too task for you this...