And since you’re reading this article, I can assume that it’s not happening with your Excel. One common issue with arrow keys in Excel is that it moves the worksheet, but the cursor doesn’t move. It’s as if the cursor is stuck in the cell and doesn’t move with the arrow key, but the worksheet page scrolls. And it has a really easy fix – the scroll lock. In this short tutorial, I will show you how to fix when arrow keys are not working as expected in your Excel file.
Disable the Scroll Lock to Fix the Arrow Keys in Excel
When scroll lock is enabled, it does exactly that – locks the scrolling. If this is the case, you will also see Scroll Lock written in the status bar in Excel (at the left side of the Status bar), as shown below: And if you want to get the original functionality of the arrow keys in Excel back, you need to disable the scroll lock.
Disabling with a Keyboard that Has the Scroll Lock Key
If you’re using a keyboard that has a numeric keypad, there is a good chance that you already have the scroll lock key. And to disable the scroll lock, you need to find the key and press it. This would disable the scroll lock. In most keyboards, there would also be a scroll lock light that would turn off, indicating that it is no longer active.
Disabling Scroll Lock with On-Screen Keyboard
With laptops getting smaller and sleeker, many keyboards don’t have the scroll lock key. So if you somehow manage to enable the scroll lock, you won’t be able to disable it with a keypress. No worries – we can use the On-Screen Keyboard. Below are the steps to do this: The above steps would disable the scroll lock and you will be able to move the cursor in Excel using the arrow keys.
Disable Add-ins and Check
In most cases, disabling the scroll lock should fix the issue. In an off chance that the issue still persists for you, there is a possibility that some add-in is interfering with the keystrokes. This can be the case if you’re using any third-party add-ins in Excel. You can troubleshoot this by disabling the add-ins and see if the arrow key issue gets fixed. Below are the steps to disable the add-ins in Excel: Once done, close the workbook and open it again and check whether the arrow keys work as expected or not. If an add-in was causing the issue, it should be fixed. You can also try and enable the add-in and see if the issue persists. Sometimes, the process of disabling and enabling the add-in takes care of the issue and you can then continue using the same add-in. So this is how you can troubleshoot in case your arrow keys are not working as expected in Excel (i.e., scrolling instead of moving the cursor). I hope you found this tutorial useful. Other Excel tutorials you may also like:
Excel Formulas Not Working: Possible Reasons and How to FIX IT! How to Turn OFF Scroll Lock in Excel? Microsoft Excel Won’t Open – How to Fix it! How to Fix Slow Excel Spreadsheets (Speed-up Excel) How to Create a Scroll Bar in Excel How to Automatically Open Specific Excel File on Startup Excel Tabs/Sheets Not Showing – How to Fix?
