How to Unlock Arrow Keys in Excel (5 Easy Ways)

Sometimes, our arrow keys get locked. We have to face many problems due to this problem But it is nothing unusual. We can solve it quite easily. In this article, We are going to explain 5 easy ways on how to unlock arrow keys in Excel.


Reasons of Arrow Keys Getting Locked in Excel

Arrow keys can get locked in many ways. Some honorable mentions are:

  • Pressing on the Scroll Lock key
  • Unchecking the Turning on Sticky Keys box
  • Enabling Add-ins options

If arrow keys get locked, we face difficulties to move the cursor from cell to cell. We even face the problem of scrolling due to the lock of arrow keys.


5 Easy Ways to Unlock Arrow Keys in Excel

1. Using Keyboard Key to Unlock Arrow Keys

We can use keyboard key to solve the unlock arrow keys problem. There is a key on the keyboard named SCROLL LOCK. Just press on it and the problem will be solved.

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


2. Clicking Unlock Button through On-Screen Keyboard

Similar to the earlier method, there is another option where we have to click on the On-Screen Keyboard button to unlock arrow keys.

Steps:

  • Go to Search
  • Write On–Screen Keyboard.
  • Now, click on the On–Screen Keyboard option.

How to Unlock Arrow Keys in Excel

  • Press on the ScrLk

Thus, the arrow keys will be unlocked.

Read More: Keyboard Shortcuts for Moving around Excel Spreadsheets


Similar Readings


3.  Turning On Sticky Keys

Check the Turn on Sticky Keys is another option to unlock arrow keys.

Steps:

  • First of all, click on the Search
  • Then, write Control Panel.
  • Select the Control Panel option.

How to Unlock Arrow Keys in Excel

  • Choose the Ease of Access Center.

  • Next, click on Make the keyboard easier to use.

How to Unlock Arrow Keys in Excel

  • Check the Turn on Sticky Keys.
  • Finally, press Apply and then OK to finish the process.

Related Content: How to Shift Rows Down in Excel (3 Simple & Easy Ways)


4. Unlock Arrow Keys by Disabling Add-ins

Excel has several Add-ins and we may need to enable them from time to time, which may occur the issue. Disabling the Add-ins is another smooth option to unlock arrow keys.

Steps:

  • Go to the File
  • From there, choose Options.

How to Unlock Arrow Keys in Excel

An Excel Options box will appear.

  • Click on Add-ins.
  • Then, pick Excel Add-ins and press on Go.

  • Uncheck all the Add-ins.
  • Finally, press OK.

How to Unlock Arrow Keys in Excel

This is a probable solution which could solve the issue.

Read More: [Fixed!] Unable to Move Cells in Excel (5 Solutions)


5. Turn Off Scroll Lock from Customize Status Bar

Turning Off the Scroll lock from the Customize Status Bar is another probable procedure to unlock arrow keys.

Steps:

  • Right-click on the Status Bar.
  • Turn Off the Scroll Lock option from the Customize Status Bar.

That’s it. Hopefully, this will unlock arrow keys in Excel.

Related Content: Excel Formula to Move Data from One Cell to Another


Conclusion

We have tried to explain 5 simple ways on how to unlock arrow keys in Excel. We hope it will help the Excel Users. For further queries, comment below. Do check our Exceldemy site for more Excel solutions.


Related Articles

Naimul Hasan Arif

Naimul Hasan Arif

Hello, I am Arif. I am an Engineer who graduated from BUET. I want to pursue an enterprising career in a progressive environment where my skills & knowledge can be enhanced to their maximum potential to contribute to the overall success and growth of the organization.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo