“Arrow Keys Not Working In Excel” [How to Fix this Issue]

Whenever you are working on an Excel spreadsheet, at that time a better way to move between cells is to use the arrow keys on your keyboard. Although these keys are present for each direction, you are also able to easily go from one cell to another with a single key-press. Today in this guide we are going to explain how to fix the “Arrow Keys Not Working In Excel”

Occassionally, it occurs that these arrow keys do not work in Excel. In some cases, they even take you to the next worksheet rather than moving to the next cell in the line. Whether you are annoyed by this behavior. So you will probably desire to find out the way to fix it.

arrow keys not working in excel

Fix the arrow keys not working in Excel problem is actually easier/simpler than you think. Similarly, in most cases, you are just a single keystroke away from getting the keys to do what they should be doing.

Turn off Scroll Lock (“Arrow Keys Not Working In Excel”)

The most common reason is that why the arrow keys do not work in Excel is. Because you have turned on the scroll lock feature on your PC. For as long as it remains turned, the keys won’t do what they are imagined to perform.

Whether you take a look at your keyboard, you will find that the light for the scroll lock button is enabled. It just specifies the lock is turned on, and you have to disable it to activate the arrow keys.

However, whether the above cause is why the arrow keys are not working in Excel on your PC, fixing it is just a matter of a keypress.

  • You have to make a start with just simply press the scroll lock button on your keyboard and the lock will be turned off.

arrow keys not working in excel

  • Now you should find that the scroll lock light is no longer, on your keyboard.

Use The On-Screen Keyboard To Disable the Scroll Lock

Whether you are using a modern PC with an equally modern keyboard. So then you probably notice that there is no scroll lock button on your keyboard. Similarly, it is because most modern equipment has done away with that button thinking most users just won’t use it.

Although the Windows has an on-screen keyboard present to help you use the keys that don’t exist on your real keyboard. So that you are also able to use it on the occasions when your real keyboard gets broken or just won’t function usually.

You are now able to use this on-screen keyboard to disable the scroll lock.

  • Go to the Start Menu and search for and organize the On-Screen Keyboard. It should open.
  • Similarly, on the right-hand side of the keyboard, here you will find all the lock keys. There will be a key named ScrLk which should help you to turn on and turn off the scroll lock on your computer. Now you have to tap on it and it will turn off the scroll lock if it was turned on before.

Fixing the Arrow Keys Not Working With An AppleScript On Mac

Although the Mac keyboards normally do not have the scroll lock button on them. So turning off the feature is quite a task for you whether you are a Mac user. However, there is a workaround that uses an AppleScript to allow you to fix the problem in Excel on your Mac.

Similarly, the workaround makes an AppleScript and runs it when you are also able to use Excel on your machine. So it then does what it has to do to receive the arrow keys to work in the Excel program.

Creating an AppleScript and executing it probably sounds a little technical. But it’s literally pretty easy to perform.

  • Here you have to tap on Launchpad, search for TextEdit, and open it.

  • Now tap on the File menu at the top. Choose the New to make a new document.
  • Now you have to copy the following code and then paste it into your document.
set returnedItems to (display dialog "Press OK to send scroll lock keypress to Microsoft Excel or press Quit" with title "Excel Scroll-lock Fix" buttons {"Quit", "OK"} default button 2)

set buttonPressed to the button returned of returnedItems

if buttonPressed is "OK" then

tell application "Microsoft Excel"
activate
end tell

tell application "System Events"
key code 107 using {shift down}
end tell

activate

display dialog "Scroll Lock key sent to Microsoft Excel" with title "Mac Excel Scroll-lock Fix" buttons {"OK"}

end if
  • Press the Command + S keys to save the file.
  • Enter FixExcelKeys.applescript as the name of the file and save it.
  • Now you have to organize your spreadsheet in Excel.
  • Double-click on the newly created AppleScript file. So then it should solve the problem for you.

Also read this article: Some Of The Best Transcription Software For Mac:

Turn on the Sticky Keys

However, in most cases, the above-mentioned methods should fix the arrow keys not working in Excel problem for you. Although whether you did not have any luck with them. So then you probably like to try a few more. Then view whether they help you resolve the issue.

One of these methods is to turn on the sticky keys feature on your Windows PC. While it is not directly related to Excel or arrow keys. It is worth toggling it to view whether it fixes the problem for you.

  • Now you have to search for Control Panel using Cortana search and organize it.
  • Simply tap on the Ease of Access Center.
  • Tap on Make the keyboard easier to use.
  • Here you have to turn on the option that says Turn on Sticky Keys and tap on OK.

Turn off the Add-Ins

Although the dd-ins help you to obtain more out of Excel. But occasionally they are able to cause conflicts as well. Whether you have any add-ins installed, you probably like to turn off them. And view whether the arrow keys then start working.

It is fairly easy and even simple to turn off the add-ins in the Excel software.

  • Organize the Excel on your PC.
  • Tap on the File menu at the top. Choose the Options from the left sidebar.
  • Tap on Add-ins in the left sidebar in order to see your Excel add-ins settings.
  • Now choose the Excel Add-ins from the scroll-down menu. Tap on Go.
  • Here you should deselect all the add-ins and tap on OK.
  • Perform the above steps for every option in the scroll-down menu. So that all of your add-ins are turned off.

Related Article: What is Shortcut Key of Rename in Windows

Conclusion (“Arrow Keys Not Working In Excel”)

When you are working on an Excel spreadsheet, at that time a better way to move between cells is to use the arrow keys on your keyboard. Although these keys are present for each direction, you are also able to easily go from one cell to another with a single key-press.

We hope your arrow keys not 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.

Leave a Reply

Your email address will not be published. Required fields are marked *