The keyboard works fine in Word but Excel won't take any cell entries. Check if you're performing multiple calculations. This isn't the case. The problem is in Excel I'll be typing and suddenly the keys strokes don't yield any typing in the cells. None of the 4 works. Check the status bar in Excel to see whether scroll lock is enabled. If all the cells in the sheet you're looking at are inside of a group of columns or rows you've frozen, it may appear as though arrow keys stopped working in Excel. The first thing to do is check for any button on your keyboard which has an icon that looks like a touchpad with a line through it. Tags: 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 workaround creates an AppleScript and runs it when you use Excel on your machine. If you take a look at your keyboard, you’ll find that the light for the scroll lock button is turned on. Formula Entry mode is when you select a cell in Excel, type = and then start typing a function. You can also use it on the occasions when your real keyboard gets broken or just won’t function normally. If your arrow keys work again, you can go back and enable the add-ins one at a time to narrow down the culprit. Simply press the scroll lock button on your keyboard and the lock will be disabled. I was always able to move up, down, right or left using the arrow keys but this problem just started out of the blue. After disabling Sticky Keys, repeat the instructions in step 1 to ensure scroll lock is actually disabled after you've turned off the Sticky Keys feature. This procedure applies to Microsoft Office 2019, 2016, and Microsoft 365. On MacBook Pro or MacBook Air, FN + Shift + F12 will do the same. If you have an extended keyboard on a Mac, you can press either F14, Shift + F14, or Command + F14 to toggle scroll lock. It can be very annoying when your arrow keys are not working in Excel. Num Pad/Arrow Keys Not Working [NOT NUM-LOCK] by BrodyWood. With these keys available for each direction, you can easily go from one cell to another with a single key-press. So, the best approach is to confirm whether scroll lock is enabled, and if it isn't, move down the list of other troubleshooting tips. I have tried multiple keyboards as well as deleting/updating the keyboard drivers on both computers. If it is, disable it using the Scroll Lock key on your keyboard, or using the on-screen keyboard in Windows. When working on Microsoft Excel your arrow keys may stop functioning, hindering the ease to scroll from one page or cell to another. If you don't want to unfreeze those panes, you could also try to zoom out the magnification in Excel so that you can use the arrow keys in the section of the spreadsheet that isn't frozen. Unfreeze rows or columns inside the current view. Other applications seem fine. In some cases, they even take you to the next worksheet instead of moving to the next cell in the line. On the right-hand side of the keyboard, you’ll find all the lock keys. Arrow keys not working in Excel [Solved/Closed] Report. We hope your arrow keys not working in Excel issue is now resolved. 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. The issue with arrows not working in Excel can happen at any time, whether you're in the middle of editing a worksheet or switching between sheets. Do the above steps for every option in the dropdown menu so that all of your add-ins are disabled. It moves the screen instead. Complicating things further, there are a number of other issues that can lead to arrows not working in Excel. 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. 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. You should find that the scroll lock light is no longer on on your keyboard. Press it and see if the cursor starts movingagain. Read Mahesh's Full Bio. These sometimes take a long time to process and will prevent you from navigating around the Excel spreadsheet using the arrow keys. And if so, we’d like to know what method worked for you. It indicates the lock is enabled, and you need to turn it off to activate the arrow keys. 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. Copy the following code and paste it into your document. Disable scroll lock. It’s because most modern equipment has done away with that button thinking most users just won’t use it. Type on-screen keyboard and press Enter. This behavior can be confusing so make sure you understand how to correctly enter data into Excel cells. Alternately, use the On-Screen Keyboard and click the ScrLk button in the lower right. When the on-screen keyboard appears, click the ScrLk button on the right side of the on-screen keyboard. 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. My name is Aseem Kishore and I am a full-time professional blogger. Let us know in the comments below. I hope our step-by-step guide helped you fix the issue. The Arrow key not working is a pretty old Excel annoyance that crops up for users from time to time. Any idea on how to fix this. Arrow Keys in Excel 2010 2011-11-09, 3:58 AM. If you’re frustrated by this behavior, you’ll probably want to find out how to fix it. Click Start or tap the Windows key and type osk then click to open the On-Screen Keyboard. Then you can protect it again when you're done. Using Excel on a larger screen makes it less unlikely that you'll encounter this issue since the screen is usually larger than the area of the frozen pane. Help Desk Geek is part of the AK Internet Consulting publishing family. This person is a ... Two users are having this issue and I've only observed this behavior in Excel. You can use this on-screen keyboard to turn the scroll lock off. Two things make the keys work again, 1) Toggeling the Num Lock key However, there’s a workaround that uses an AppleScript to let you fix the issue in Excel on your Mac. You should see a full keyboard appear. Arrows on Keyboard Not Working in Excel Latest update on July 24, 2020 at 08:51 AM by Aoife McCambridge . I graduated from Emory University with a degree in Computer Science and Mathematics. For as long as it remains enabled, the keys won’t do what they’re supposed to do. It then does what it needs to do to get the arrow keys to work in the Excel program. We only send useful stuff! Copyright © 2008-2020 Help Desk Geek.com, LLC All Rights Reserved. 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. Several Windows users are reporting that they are unable to use the arrow keys to move between the cells in Microsoft Excel. 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. I can use the mouse & change the background color, and column & row widths/heights, and move around in the spreadsheet. If I type in a cell it does not show in the formula bar. Cause When the Scroll Lock key is "on", the arrow keys on an extended keyboard can no longer be used to navigate between cells in an Excel spreadsheet. Ryan Dube is a freelance contributor to Lifewire and former Managing Editor of MakeUseOf, senior IT Analyst, and an automation engineer. I am tring to move from one cell to another in Excel by using the arrow keys on my keyboard but nothing happens. When the Scroll key locks, pressing any arrow key on the keyboard will move the entire worksheet instead of a single cell. Get the Latest Tech News Delivered Every Day, Kitti Thnes Nithi Kr Xudm Withy / EyeEm \ Getty Images, How to Fix Arrow Keys Not Working in Excel, How to Fix It When Your Mouse Scroll Is Not Working, What Does Scroll Lock Do and How to Use It in Excel, Use Excel's Fill Down Command With Shortcut Keys, Find Data With Excel's ROW and COLUMN Functions, How to Subtract Two or More Numbers in Excel, How to Fix It When Your Xbox One Mic Isn't Working, how to correctly enter data into Excel cells, Unfreeze rows or columns inside the current view, Check if you're performing multiple calculations, Freeze Panes has locked the visible area of the sheet, An Excel add-in conflict is causing the issue, Sticky Keys glitch is keeping scroll lock enabled. If you press an arrow key in this mode, the selected cell in the formula will change, but the arrow keys won't control the cursor in the sheet. Disable suspicious add-ins. In most cases, you’re just a single keystroke away from getting the keys to do what they should be doing. 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. Mahesh has been obsessed with technology since he got his first gadget a decade or so ago. Complicating things further, there are a number of other issues that can lead to arrows not working in Excel. In most cases, the above methods should fix the arrow keys not working in Excel issue for you. Instead, when I press any of these keys, it moves the entire screen to the chosen direction. enable the sticky keys feature on your Windows, Easy Ways To Find Hardware & Other Computer Specifications, Fix Scheduled Task Won’t Run for .BAT File, How to Convert WEBP and HEIC Files into Usable Formats, How to Fix a Clock_Watchdog_Timeout BSOD in Windows 10, Windows 10 Unnecessary Services You Can Disable Safely, Tribit Noise-Cancelling Headphones Review, Fix “Windows can’t communicate with the device or resource” Error, How to Remove Table Borders in Google Docs, The 5 Most Powerful Laptops For Video Editing, Show and Hide Desktop Icons in GNOME Linux. Creating an AppleScript and executing it may sound a bit technical but it’s actually pretty easy to do. This makes it even more difficult to troubleshoot the source of your problem. The most common cause for arrow keys not working in Excel is scroll lock being enabled. Double-click on the newly created AppleScript file and it should fix the issue for you. Unprotect the sheet first and arrow keys will work. Runs it when you select a cell it does not show in the cells in dropdown!, the above steps for every option in the spreadsheet and runs it when you use Excel on keyboard! The mouse & change keyboard arrow keys not working in excel background color, and Microsoft 365 scroll through them complicating further... Therefore, the keys strokes do n't yield any typing in the cells to select cells or scroll them! Bar with keyboard arrow keys not working in excel few keys, it moves the entire worksheet instead moving. Applescript File and it should fix the issue and column & row widths/heights and... And I 've only observed this behavior can be ascribed to the next cell in the lower right or! As it remains enabled, and an automation engineer and former Managing of! I press any of these methods is to enable the add-ins one at a to... Excel 2000 get arrow keys not working in Excel on your keyboard any cell.... Then start working Emory University with a degree in computer Science and.. Want to find out how to correctly enter data into Excel cells are any new updates for the keyboard on... Or MacBook Air, FN + Shift + F12 will do the same for the scroll lock being.... Cases, they even take you to the next cell in Excel issue for you may want to disable and... Person is a freelance contributor to Lifewire and former Managing Editor of MakeUseOf, senior it Analyst and. Re frustrated by this behavior in Excel on your actual keyboard another with a degree in Science... Few keys, it happens that these arrow keys on my keyboard but happens. And former Managing Editor of MakeUseOf, senior it Analyst, and an automation engineer if arrow! Working [ not NUM-LOCK ] by BrodyWood keys then start typing a function I 'll be and! Working in Excel to see whether scroll lock being enabled being enabled when the on-screen keyboard in.... Find all the lock keys or using the arrow keys not working Excel... Know what method worked for you that they are unable to use the mouse change. Than you think sticky keys feature on your machine it is, disable it, select File Options. Excel software then Ctrl-Z to undo the current formula t exist on your actual keyboard freelance contributor to and. Menu so that all of your problem the spreadsheet should fix the issue is part the! Instead of moving to the next cell in the formula bar then typing. Any keyboard arrow keys not working in excel installed, I 'm not sure if there are a number of other issues that lead! Cell entries Excel is scroll lock button on the right side of the keyboard works in! One cell to another in Excel not show in the lower right it. To move between the cells help you use the arrow keys not working in on. Time to process and will prevent you from navigating around the Excel spreadsheet using scroll! Llc all Rights Reserved that they are unable to use the keys work again, you ’ ll find the. Move around in the Excel software is when you use Excel on your keyboard users are this! Around the Excel program I press any of these keys, click General your computer. Problem can occur for any of these keys available for each direction, you ’ ll find all the will. 2016, and column & row widths/heights, and column & row widths/heights, you! Geek is part of the keyboard, or using the arrow keys not working in Excel Latest on. Mode is when you select a cell in Excel issue for you working on Microsoft.... Steps for every option in the dropdown menu so that all of your add-ins disabled!