Share this article
Improve this guide
Arrow Keys Not Working in Excel: Fixed in 4 Easy Ways
Make sure that Scroll Lock and Sticky Keys are turned off
3 min. read
Updated onOctober 4, 2023
updated onOctober 4, 2023
Share this article
Improve this guide
Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more
Key notes
Excelusers can navigate spreadsheets with their mice and keyboards. When users press the arrow keys, they can usually navigate the spreadsheets by moving between cells.
For example, pressing the down arrow key will select the next cell down from the one selected, which will eventually scroll the sheet downwards.
However, some Excel users have said inforum poststhat arrow keys not working in excel, namely, they cannot move from cell to cell by pressing their keyboards’ arrow keys.
Instead, thespreadsheetjust scrolls straight down, up, left, or right when they press the arrow keys much the same as when pressing the scroll bars’ buttons.
Therefore, those users have wondered how they restore the original arrow key functionality so that they can move an Excel spreadsheet to the next cell.
Why do my arrow keys not work in Excel?
If you cannot navigate using your arrow keys, it’s most likely because of your settings.
Of course, it’s also important to make sure that your hardware is actually working properly and that yourkeyboard drivers are up-to-date.
In most cases, users reporting having this issue had their scroll lock enabled and were able to use the arrow keys once they disabled it. Learn below how to do that and a few other tricks that should help.
How to fix the Excel spreadsheet arrow keys not workingissue?
1. Press the Scroll Lock keyboard key
Excel users can’t navigate Excel spreadsheet cells with arrow keys when Scroll Lock is enabled. You can check if Scroll Lock is on by right-clicking the status bar at the bottom of Excel’s window to open the menu shown directly below.
That menu tells you if Scroll Lock is on or off. However, clicking Scroll Lock on the menu will only stop the status bar from showing if Scroll Lock is on.
Turning Scroll Lock off will fix this issue for most users. If your keyboard includes a Scroll Lock key, press that button. Some users might need to press an ScrLk key to turn SL off.
2. Turn off Scroll Lock with the On-Screen keyboard (worked for most users) ✅
- Launch the Run dialog by pressing theWindows +Rkeys at the same time.
2.Enteroskin Run, and press theOKbutton.
- The On-Screen Keyboard will now open.
4.Click theScrLk keyon it to turn off Scroll Lock.
-
Close the On-Screen keyboard.
-
Try navigating an Excel spreadsheet with the arrow keys and see if it works.
As long as you have Scroll Lock enabled on your keyboard, the arrow keys will not work properly in Excel. If your keyboard is not working, you can use the On-Screen keyboard to turn this feature off.
3. Start Excel in Safe Mode
An Excel add-in conflict can sometimes stop users from navigating Excel spreadsheet cells with their keyboards’ arrow keys.
To fix that, try opening Excel in Safe Mode, which launches the application without superfluous add-ins. You can do that by entering ‘excel /safe’ in Run and clickingOK.
If that fixes the issue, then an add-in is probably the culprit. In this case, you’ll need to disable the add-in by clickingFile>Options>Add-insin Excel.
Then selectExcel Add-inson the Manage drop-down menu, and click theGobutton. Thereafter, you can uncheck the checkboxes for Excel add-ins to selectively disable them.
4. Turn Off Sticky Keys
The above resolutions have fixed Excel’s spreadsheet cell keyboard navigation for lots of users.
If you’re aware of another way to solve this problem, share it in the comments section below so that other users can try it, as well.
More about the topics:Excel
Matthew Adams
Windows Hardware Expert
Matthew is a freelancer who has produced a variety of articles on various topics related to technology. His main focus is the Windows OS and all the things surrounding it.
He is passionate about the tech world, always staying up-to-date with the latest and greatest. With an analytical view, he likes problem-solving, focusing on errors and their causes.
In his free time, he likes to read and write about history and tries to always develop new skills.
User forum
0 messages
Sort by:LatestOldestMost Votes
Comment*
Name*
Email*
Commenting as.Not you?
Save information for future comments
Comment
Δ
Matthew Adams
Windows Hardware Expert
He is passionate about everything surrounding Microsoft’s OS, focusing on troubleshooting guides & tips for everyday problems.