The up and down arrows on your keyboard are the best way to navigate between cells when you’re working on an Excel spreadsheet. With these keys available in each direction, switching from one cell to another is simple and only requires pressing one key. These arrow keys in Excel sometimes stop working. In this article, we will see some easy solutions to up and down arrows not working in Excel.
Download Practice Workbook
Download the practice workbook from here.
8 Possible Solutions When Up and Down Arrows Are Not Working in Excel
In Excel, the arrow keys not working can be resolved more quickly than you might imagine. Most of the time, all it takes is one keystroke to make the keys do their intended function. This article will demonstrate how to fix Excel’s up and down arrow key issues with 8 possible solutions. So without further delay, let’s get started.
1. Turn Off Scroll Lock in Keyboard
If your keyboard’s scroll lock is on, you won’t be able to use the up and down arrows. Therefore, disabling your scroll lock is the first step in fixing arrow keys that won’t operate in Excel. Here, we will discuss two methods to turn off the scroll lock on the keyboard.
1.1 Use Keyboard Manually
If the light of the scroll lock button on the keyboard is on, then the up and down arrow keys will not work. Now, to solve this issue, simply press the Scroll lock key on a Windows PC to disable it.
We can find the scroll lock key in the control keys segment of a keyboard which is above the up and down arrow keys.
1.2 Apply On-Screen Keyboard
The majority of PCs today don’t have scroll locks on their keyboards. Nevertheless, you may disable the scroll lock without a keyboard.
There are keys available on the On-Screen Keyboard in Windows that are not present on the actual keyboard. Follow the steps below for using the On-Screen Keyboard to solve up and down arrow key problems.
- In the beginning, search for and start On-Screen Keyboard from the Start menu.
- Then, the On-Screen Keyboard will appear.
- Subsequently, take a look at the On-Screen Keyboard‘s right side. There you can see all the lock keys.
- If the scroll lock is activated, clicking the ScrLk key will disable it.
2. Enable Excel Sticky Keys Feature
Enabling the Sticky Keys capabilities on your Windows PC is another solution to the arrow keys not functioning in Excel issue. However, the arrow keys and your Excel application are not directly related to the Sticky Keys, but you can try toggling it to see whether that resolves the problem. To do so, follow the steps below.
- First, open the Control Panel on your system by typing it in the search bar.
- Secondly, click on the Ease of Access option.
- Thirdly, select the Ease of Access Center.
- Fourthly, click on the Make the keyboard easier to use option. Whereas, some operating systems may require you to click Change how your keyboard works before showing this section.
- In the end, activate the checkbox that reads Turn on Sticky Keys. Select OK.
- On the other hand, to activate Sticky Keys, quickly press the Shift key five times.
- Finally, click Yes in the pop-up dialog window.
3. Disable Excel Scroll Lock
Try a fast test to determine if your arrow keys are functioning in other apps if your Excel arrow keys aren’t moving cells. If so, Excel itself may be the problem.
Excel includes a built-in Scroll Lock feature also. If it’s on, that could be the cause of your cursor not moving in Excel. Fortunately, fixing it is rather simple. The steps to do so are below.
- In the first place, open a fresh or previously saved spreadsheet after launching Microsoft Excel.
- After that, right-click the Status bar, which is located at the bottom of your worksheet. Look for options like the zoom slider and Page Layout if you’re having difficulties finding it.
- Then, locate Scroll Lock in the Status bar menu.
- If the feature is marked as On, click it once to deactivate it.
Read More: [Fixed!] CTRL C Not Working in Excel
4. Exit Formula Entry Mode in Excel
You might be in Excel’s formula entering mode if you notice that your up and down arrow keys aren’t moving.
This indicates that you first started typing a function after selecting a cell and typing ‘=’ just like the screenshot below.
If you hit an arrow key, in this case, the formula’s selected cell will change, but it won’t move the worksheet’s cursor. In the picture below we can see that after pressing the Up arrow key the selected cell of the formula is changed from C5 to C4.
Therefore, press Enter, followed by Ctrl-Z to undo the formula and leave entering mode, bringing back the arrows. Now, the arrow keys will work properly.
- How to Set Intervals on Excel Charts (2 Suitable Examples)
- Descriptive Statistics – Input Range Contains Non-Numeric Data
- How to Remove Last Modified By in Excel (3 Ways)
- If a Value Lies Between Two Numbers Then Return Expected Output in Excel
5. Unfreeze Excel Rows and Columns
You might think that the arrow keys have stopped functioning if you’re viewing cells contained within a collection of frozen rows or columns. If you want to Unfreeze the rows or columns then go to the View tab > Freeze Panes > Unfreeze Panes.
6. Disable Excel Add-Ins
Although Excel add-ins are helpful, they can occasionally pose issues when using the program. If you want to use the Excel arrow key scroll, you might have to disable any Excel Add-ins that you’ve previously installed. By following the actions below, you may easily disable Excel Add-ins.
- First, open Excel on your computer.
- Then, go to the File menu.
- Next, click on Options.
- After that, select Add-ins > Manage > Excel Add-ins > Go.
See the screenshot below for a better understanding.
- Now, uncheck all the Add-ins available and then click OK.
Note: You can use the same procedures to re-enable the add-ins in the Add-ins dialog box if the arrow keys begin functioning again.
7. Unprotect Excel Worksheet
If your worksheet is protected or locked, it will be similar to the frozen panes in that you won’t be able to choose or navigate between cells or use the arrow keys throughout the worksheet. In such cases, you must unprotect the Excel sheet to use arrow keys on the sheet. Steps to unprotect an Excel worksheet are below.
- Firstly, go to the Review tab and select the Unprotect Sheet from the Protect group.
- Now, a window named Unprotect Sheet will pop up.
- Next, type the Password in the box which you used for protecting the worksheet.
- Finally, click OK.
8. Update Keyboard Drivers
Outdated keyboard drivers are another factor contributing to your arrow keys not functioning. Consequently, updating your drivers may solve the issue.
- To update the keyboard drivers, at first, search for the Run See the picture below for a better understanding of the process.
- Now, the Run command will open.
- At this time, type ‘devmgmt.msc’ in the Open box and press Enter.
- After that, double-click on the Keyboards in the Device Manager control panel.
- Next, right-click the ‘HID Keyboard Device’ and choose ‘Update driver’ afterward.
- Finally, click the ‘Search automatically for updated driver software’ option and wait for the update to finish.
I hope the above methods will be helpful for you to fix the problems when up and down arrows are not working in Excel. Download the practice workbook and give it a try. Let us know your feedback in the comment section. Follow our website ExcelDemy to get more articles like this.
- How to Add Trailing Zeros in Excel (2 Easy Ways)
- Calculate WACC in Excel (with Easy Steps)
- How to Make a Box Plot in Excel (With Easy Steps)
- Make a Forest Plot in Excel (2 Suitable Examples)
- How to Calculate Cost of Funds in Excel (with Easy Steps)
- Make Sankey Diagram in Excel (with Detailed Steps)
- How to Calculate APR in Excel (3 Simple Methods)
- Make a Venn Diagram in Excel (3 Easy Ways)