[Fix]: Arrow Keys Not Moving Cells in Excel (2 Methods)

Get FREE Advanced Excel Exercises with Solutions!

When all is operating properly, you would anticipate the cursor to go to the cell to the right or left when you press the right or left arrow keys in Excel. A typical problem with arrow keys is that they move the spreadsheet but not the pointer. In this tutorial, we will illustrate how to fix arrow keys not moving between cells in Excel.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


2 Easy Ways to Fix Arrow Keys Not Moving Between Cells in Excel

When your Scroll Lock key is activated, the cells usually do not move. The Scroll Lock key is enabled in the spreadsheet, as shown in the image below. Another cause of this difficulty is the activation of any add-ins. We’ll show you three simple solutions to remove this problem.

Easy Ways Fix Arrow Keys Not Moving between Cells in Excel

1. Turn Off the Scroll Lock Key to Fix Arrow Keys Not Moving Between Cells in Excel

As shown in the image below, the Scroll Lock is active. So, when we press the right arrow (→) is moved the page is stead of the cell. Thus, It remains in the B5 cell as before. Follow the steps below to get rid of the issue.

Easy Ways Fix Arrow Keys Not Moving between Cells in Excel

1.1 Use a Keyboard Shortcut to Turn Off the Scroll Lock Key

Steps:

  • Press the  Scroll Lock  key from your keyboard to turn off the Scroll Lock.
  • Then, press the right arrow key (→). Now, it will shift cell B5 to C5.

Easy Ways Fix Arrow Keys Not Moving between Cells in Excel

1.2 Use On-Screen Keyboard to Turn Off the Scroll Lock Key

You can also use On-Screen Keyboard to do the same task. Follow the outlined steps below to do so.

Step 1:

  • In your windows search box, type On-Screen Keyboard.
  • Click on the On-Screen Keyboard.

Easy Ways Fix Arrow Keys Not Moving between Cells in Excel

Step 2:

  • Then, click on the  ScrLk.

Easy Ways Fix Arrow Keys Not Moving between Cells in Excel

Step 3:

  • Go back to your spreadsheet and press the right arrow key (→).
  • Therefore, it will work as you expected.

Easy Ways Fix Arrow Keys Not Moving between Cells in Excel

 Notes.  Shortcut to open the On-Screen Keyboard:  Windows +  Ctrl + O 

Read More: How to Move Selected Cells in Excel with Keyboard (4 Methods)


Similar Readings


2. Remove Add-ins to Fix Arrow Keys Not Moving Between Cells in Excel

If disabling the Scroll Lock does not solve the problem, you may have any add-ins enabled. As a result, you must deactivate the add-ins. To do so, follow the steps below.

Step 1:

  • Go to the File tab and select Home.
  • Click on the Options.

Sample Data

Step 2:

  • Select the Add-ins.
  • Choose the COM Add-ins from the Manage.
  • Then, click on the Go.

Sample Data

Step 3:

  • Disable all the Checkboxes.
  • Finally, click OK.

Sample Data

Step 4:

  • Close your workbook and reopen it.
  • Now, your arrow key will work as shown in the screenshot below.

Sample Data

Read More: How to Move Cells Up in Excel (3 Easy Ways)


Conclusion

In conclusion, I hope you now understand how to resolve the issue of arrow keys not moving cells in Excel. All of these strategies should be employed in order to teach and practice with your data. Examine the practice book and apply what you’ve learned. We are encouraged to continue giving sessions like these because of your important support.

Please do not hesitate to contact us if you have any queries. Please share your thoughts in the comments section below.

The Exceldemy team will get back to you as soon as possible.

Stay with us and continue to learn.


Related Articles

Tags:

Bhubon Costa

Bhubon Costa

Myself, Bhubon Costa, an engineer, is currently employed with Exceldemy as an Excel & VBA Content Developer. I appreciate solving analytical difficulties, finding practical answers, and, for the most part, I enjoy taking on new tasks. I write articles on Exceldemy about various ways to get out of Microsoft Excel's stuck conditions. My passion is to leave my mark on the world through my work and to have an impact on the community who benefit from it.

2 Comments
  1. thank you very nice

    • Thanks a lot for your appreciation. You can also put your problems here, the ExcelDemy team is always in your assistance.

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo