When yous're working on an Excel spreadsheet, the all-time way to move between cells is to use the arrow keys on your keyboard. With these keys bachelor for each management, you lot tin hands become from one prison cell to another with a single key-press.

Sometimes, it happens that these arrow keys do not work in Excel. In some cases, they even take you to the side by side worksheet instead of moving to the next cell in the line. If you're frustrated past this behavior, yous'll probably want to find out how to fix information technology.

Fixing the arrow keys not working in Excel issue is actually easier than y'all think. In almost cases, you're just a single keystroke away from getting the keys to do what they should be doing.

Also, be sure to watch our YouTube video where we go through the unlike solutions mentioned in this article in a brusque and compact video.

Disable Gyre Lock

1 of the mutual reasons why the arrow keys don't work in Excel is because yous've enabled the curl lock characteristic on your calculator. For as long equally information technology remains enabled, the keys won't do what they're supposed to do.

If you take a look at your keyboard, you'll detect that the light for the scroll lock button is turned on. It indicates the lock is enabled, and y'all need to turn it off to activate the arrow keys.

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 cardinal press.

  • Simply printing the scroll lock push button on your keyboard and the lock will be disabled.
  • You should find that the roll lock lite is no longer on on your keyboard.

Apply The On-Screen Keyboard To Plough Off Scroll Lock

If you're using a modern computer with an as modernistic keyboard, you may discover that there's no ringlet lock button on your keyboard. Information technology's considering most modern equipment has washed away with that button thinking virtually users just won't use it.

All the same, Windows has an on-screen keyboard available to help you utilise the keys that don't exist on your bodily keyboard. Yous can also apply it on the occasions when your real keyboard gets broken or merely won't function unremarkably.

You can utilize this on-screen keyboard to turn the scroll lock off.

  • Open the Showtime Menu and search for and launch On-Screen Keyboard. It should open.
  • On the right-hand side of the keyboard, yous'll find all the lock keys. There'll be a key named ScrLk which should assistance y'all enable and disable scroll lock on your PC. Click on it and it'll disable the gyre lock if it was enabled before.

Fix Pointer Keys Non Working With An AppleScript On Mac

Mac keyboards ordinarily don't have the ringlet lock button on them and then disabling the characteristic is quite a task for you if you're a Mac user. However, there's a workaround that uses an AppleScript to permit you fix the issue in Excel on your Mac.

The workaround creates an AppleScript and runs it when you use Excel on your machine. It then does what it needs to exercise to get the arrow keys to work in the Excel programme.

Creating an AppleScript and executing information technology may sound a flake technical simply it's actually pretty easy to do.

  • Click on Launchpad, search for TextEdit, and open it.
  • Click on the File carte at the top and select New to create a new certificate.
  • Copy the following code and paste it into your document.
              set returnedItems to (display dialog "Press OK to ship ringlet lock keypress to Microsoft Excel or press Quit" with title "Excel Scroll-lock Gear up" buttons {"Quit", "OK"} default button 2)              
                set buttonPressed to the push button returned of returnedItems              
              
                if buttonPressed is "OK" then              
              
                tell application "Microsoft Excel"                
                activate                
                stop tell              
              
                tell awarding "System Events"                
                cardinal code 107 using {shift downward}                
                cease tell              
              
                actuate              
              
                display dialog "Scroll Lock central sent to Microsoft Excel" with title "Mac Excel Scroll-lock Prepare" buttons {"OK"}              
              
                end if
  • Printing the Control + S keys to salve the file.
  • Enter FixExcelKeys.applescript as the name of the file and relieve it.
  • Launch your spreadsheet in Excel.
  • Double-click on the newly created AppleScript file and it should fix the effect for you.

Enable Pasty Keys

In most cases, the in a higher place methods should gear up the pointer keys not working in Excel result for yous. Nonetheless, if you didn't have any luck with them, you might want to try a few more and run into if they help y'all resolve the problem.

One of these methods is to enable the gluey keys feature on your Windows computer. While it isn't direct related to Excel or arrow keys, it's worth toggling it to see if it fixes the issue for y'all.

  • Search for Control Panel using Cortana search and launch it.
  • Click on Ease of Access Center.
  • Click on Make the keyboard easier to use.
  • Enable the option that says Plow on Sticky Keys and click on OK.

Disable Add together-Ins

Add-ins help you get more out of Excel just sometimes they can crusade conflicts as well. If you take whatsoever add-ins installed, you may want to disable them and run into if the pointer keys then start working.

It'south fairly easy to disable add together-ins in the Excel software.

  • Launch Excel on your figurer.
  • Click on the File menu at the top and select Options from the left sidebar.
  • Click on Add together-ins in the left sidebar to view your Excel add-ins settings.
  • Select Excel Add together-ins from the dropdown menu and click on Go.
  • Deselect all the add together-ins and click on OK.
  • Do the above steps for every choice in the dropdown menu so that all of your add-ins are disabled.

We hope your pointer keys non working in Excel issue is now resolved. And if so, we'd like to know what method worked for you. Let us know in the comments below.