How to Remove Scroll Lock in Excel (With Easy Steps)

Usually, the Scroll Lock feature stays disabled in our Excel worksheet. But accidentally it may get turned On. When it’s On, we may find it inconvenient to work in Excel with datasets as we need to navigate through cells now and then. In this article, we will show you the Step-by-Step Guidelines to Remove Scroll Lock in Excel.


Download Practice Workbook

Download the following workbook to practice by yourself.


Introduction to Scroll Lock in Excel

The Scroll Lock feature deals with the behavior of the Keyboard Arrow Keys in Excel. When the feature is off, we can use the up, down, left, and right arrow keys to navigate through different cells and also select them. However, if the feature is on, the arrow keys won’t navigate through cells, rather they will just change the worksheet viewing area. In the following dataset, we can see the ‘Scroll Lock’ in the bottom left corner which is the status bar of the Excel worksheet. The writing appears only when the feature is on.

Introduction to Scroll Lock in Excel

For instance, here we select the B1 cell.

Now, press the down arrow key. You’ll see that the worksheet area goes one row down without changing the selected cell B1.

Note: Press the Ctrl and Backspace keys together to scroll back to the active cell.


Step by Step Procedures to Remove Scroll Lock in Excel

Now, follow the below steps carefully to Remove the Scroll Lock in Excel.

STEP 1: Type ‘on-screen keyboard’

  • Firstly, press the Windows icon.
  • Then, type ‘on-screen keyboard’.
  • As a result, you’ll see the On-Screen Keyboard app as it’s shown in the following picture.
  • Subsequently, select the App.

Remove Scroll Lock in Excel

Read More: How to Turn On/Off Scroll Lock in Excel (2 Ways)


STEP 2: On-Screen Keyboard Display

  • Consequently, the On-Screen Keyboard will appear on the display screen.
  • There, the ScrLK key will be in green color as the Scroll Lock feature is on.

Remove Scroll Lock in Excel


STEP 3: Press ScrLK

  • After that, press the ScrLK key to turn off the Scroll Lock feature.

Remove Scroll Lock in Excel

Read More: How to Turn Off Scroll Lock in Excel


Final Output to Remove Scroll Lock in Excel

Lastly, the Scroll Lock feature is disabled and the ‘Scroll Lock’ writing will disappear from the status bar.


What to Do If Scroll Lock Is Not Visible in Excel?

However, you may not see the ‘Scroll Lock’ writing in the status bar even when it’s on. To have it on display, follow the below steps.

STEPS:

  • Right-click the status bar.
  • Select the ‘Scroll Lock’ option and a tick mark will appear like it’s shown in the below image.
  • Thus, you’ll see the ‘Scroll Lock’ writing in the status bar whenever you enable the feature. The following picture shows the simple process.


Conclusion

Henceforth, you will be able to Remove Scroll Lock in Excel following the above-described steps. Keep using them and let us know if you have any more ways to do the task. Follow the ExcelDemy website for more articles like this. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles

Aung

Aung

I'm Aung. Recently I've earned my B.Sc. Degree in Electrical and Electronic Engineering. From now on, I will be working in Microsoft Excel and other useful software, and I’ll upload articles related to them. My current goal is to write technical contents for anybody and everybody that will make the learning process of new software and features a happy journey.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo