Way To Fix The Issue Arrow Keys Not Working In Excel

 Arrow Keys Not Working In ExcelHowever, when you guys are working on an Excel spreadsheet, the perfect way to move b/w cells is to use the arrow keys on your keyboard. However, with these keys that are available for each direction, you are also able to easily go from one cell to another with a single key-press. In this guide, you will learn the way to Fix The Issue Arrow Keys Not Working In Excel.

Occassioanlly, it occurs that these arrow keys don’t work in Excel. Though in some cases, they even take you just to the next worksheet rather than moving to the next cell in the line. Whether you guys are annoyed by this behavior, though you will probably want to find out the way to fix it.

Way To Fix The Issue Arrow Keys Not Working In Excel

Resolving the arrow keys not working in Excel issue is basically too easier than you think. Similarly, in most cases, you guys are just a single keystroke away from getting the keys to do what they should be doing.

Read: Way to Organize a Windows XP Virtual Machine for Free

Turn off the Scroll Lock To Fix The Issue Arrow Keys Not Working In Excel

Though one of the usual causes so that why the arrow keys do not work in Excel is just because that you have turned on the scroll lock feature on your PC. For as long as it remains turned on, so then the keys won’t do what they are supposed to do.

Whether you take a look at your keyboard, so then you guys will also find that the light for the scroll lock button is enabled. It simply specifies that the lock is enabled, & you just have to turn it off to activate the arrow keys.

Whether the above purpose is why though the arrow keys are not working in Excel on your PC, simply resolving it is just a matter of a keypress.

  • First of all, you have to press the scroll lock button on your keyboard and the lock will also be disabled.
  • Here 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 guys are using a modern PC with an equally modern keyboard, you probably notice that there is no scroll lock button on your keyboard. Though it is just because most current equipment has done away with that button simply thinking most users just won’t use it.

But the Windows also has an on-screen keyboard available in order to help you use the keys that do not exist on your real keyboard. You are also able to use it on occasions when your real keyboard simply gets broken or just won’t work usually.

You guys are also able to use this on-screen keyboard in order to turn the scroll lock off.

  • First of all, you have to head to the Start Menu and search for and organize the On-Screen Keyboard. It should open.
  • Now on the right-hand side of the keyboard, you guys will also find all the lock keys. There will also be a key named ScrLk which should support you to enable& also disable scroll lock on your PC. Tap on it and it’ll turn off the scroll lock whether it was turned on before.

Also, see Hiberfil. sys: Explain Hiberfil. sys & How To Delete It?

Resolve the Arrow Keys Not Working With An AppleScript On Mac

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

Similarly, the workaround makes an AppleScript & also runs it when you guys use Excel on your machine. Though it then does what it needs to perform in order to get the arrow keys to work in the Excel program.

Simply creating an AppleScript & also executing it probably sound a bit technical. But it’s basically pretty easy to do.

  • First of all, tap on Launchpad, search for TextEdit, & open it.
  • Now tap on the File menu at the top and choose New to make a new document.
  • Now you must copy the following code and 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
  • Simply here you should press the Command + S keys to store the file.
  • Here enter FixExcelKeys.applescript as the name of the file a& then save it.
  • Organize your spreadsheet in Excel.
  • Now double-click on the currently created AppleScript file & then it should also fix the issue for you.

Turned on the Sticky Keys

In most situations, the above processes should resolve the arrow keys not working in Excel issue for you. Though whether you guys did not have any luck with them. So you probably want to try a few more & see whether they help you fix the problem.

Therefore one of these methods is to turn on the sticky keys feature on your Windows PC. Whilst it is not directly related to Excel or arrow keys. Though guys it’s worth toggling it to see whether it resolves the issue for you.

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

Turn off the Add-Ins

Add-ins support you to get more out of Excel. However, occassioanlly they can cause conflicts as well. Whether you guys have any add-ins installed. You probably want to turn off them and see whether the arrow keys then start working.

It’s justly too easy to turn off the add-ins in the Excel software.

  • First of all, you have to organize the Excel on your computer.
  • Tap on the File menu at the top and choose Options from the left sidebar.
  • Tap on Add-ins in the left sidebar to see your Excel add-ins settings.
  • Choose Excel Add-ins from the scroll-down menu and tap on Go.
  • 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.

Must read this article: Ways To Disable Microsoft Edge From Windows 10

Conclusion

Well, we hope your arrow keys not working in Excel issue is now fixed. And whether so, we would also like to know that 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 *