Excel sheet is often lauded as one of the most utilitarian pieces of software. With the help of Excel, we can create spreadsheets, crunch numbers and prepare a business report. Generally, we press arrow keys to move from one cell to another. However, sometimes pressing arrow keys will move the entire worksheet.
Arrows keys not working in Excel
Are you frustrated that pressing the arrow key is moving the entire spreadsheet instead of a single cell? You are not alone. This is a very common occurrence, and in this article, we will tell you how to fix Arrow Keys not working in Microsoft Office. This particular error occurs due to unintended behavior of Scroll Key. Fret not, in this article we will walk you through a simple and easy solution to fix this problem.
1] Disable Scroll Lock
Disabling Scroll Lock key was easy, but newer laptops don’t come with Scroll Lock. If your keyboard doesn’t come with scroll key, you need to press “Fn” and disable the Scroll Lock. That apart you can also use the on-screen keyboard and turn off the Scroll Lock. The Scroll Lock status is displayed on the Excel sheet; this will help you to double check. Additionally, you can use SHIFT+F14 to toggle the Scroll Lock to the Off Position.
Follow the steps below to bring up the on-screen keyboard:
- Press the Windows Key
- Type on-screen keyboard and press Enter.
Observe the screenshot. The Scroll Lock is in On position since the “ScrLk” key is in blue. Click on the “ScrLk” key to turn off the Scroll Lock. Make sure that the key is not in blue. As we explained earlier, you can use the Scroll Lock indicator in the status bar. Meanwhile, you can also disable/enable the scroll key by using the feature on Microsoft Excel, as shown in the image.
2] Turn on the Sticky Key
Disable Scroll Lock didn’t work? Well, try this method. Many users have reported that the Arrow Keys issue on Excel is fixed by enabling Sticky key. Follow the steps below to enable Sticky Key,
- Type Control Panel in Start Menu
- Click on Control Panel
- Select Turn On Sticky Keys option and click OK
- Go back and uncheck the Turn On Sticky Keys option
The malfunctioning Arrow keys on Excel should be fixed by now.
The Arrow key not working is a pretty old Excel annoyance that crops up for users from time to time. I hope our step-by-step guide helped you fix the issue.
- Tags: Excel