How to Unlock Arrow Keys in Excel (2 Ways)

Method 1 – Using the Keyboard Key

Almost all keyboards contain a dedicated Scroll Lock key that you can use to turn off the Scroll Lock and unlock the arrow keys. Depending on your keyboard, the functionality of the Scroll Lock key might differ.

To unlock the arrow keys in Excel using your keyboard, follow the steps below:

  • For Windows: Press Scroll Lock
  • For Mac: Press F14
    If there is no Fn key, try pressing SHIFT/CONTROL/OPTION/COMMAND+F14 depending on the settings.
  • For Dell laptops: Press the Fn+S
  • For HP/Lenovo laptops: Press the Fn+C

Using Designated Keyboard Button to Turn Off Scroll Lock

Method 2 – Using the On-Screen Keyboard

If you don’t have a Scroll Lock key and your keyboard shortcuts are not working, you can try the following method. The on-screen or virtual keyboard is an application that emulates a standard keyboard.

The on-screen keyboard is available in Windows 7 and later versions of Windows.

To unlock your arrow keys in Excel using the on-screen keyboard, follow the steps below:

  1. Go to the Windows Search Bar and type “On-Screen Keyboard”.
  2. Click on the On-Screen Keyboard application.

    How to Unlock Arrow Keys in Excel

    The on-screen keyboard will appear.

  3. Click on the ScrLK button.

This will turn off Scroll Lock and unlock the arrow keys.


Related Articles

<< Go Back to Excel Scroll Lock | Navigation in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Naimul Hasan Arif
Naimul Hasan Arif

Naimul Hasan Arif, a BUET graduate in Naval Architecture and Marine Engineering, has been contributing to the ExcelDemy project for nearly two years. Currently serving as an Excel and VBA Content Developer, Arif has written more than 120 articles and has also provided user support through comments His expertise lies in Microsoft Office Suite, VBA and he thrives on learning new aspects of data analysis. Arif's dedication to the ExcelDemy project is reflected in his consistent contributions and... Read Full Bio

2 Comments

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo