Aung Shine
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.
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.
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.
STEP 3: Press ScrLK
- After that, press the ScrLK key to turn off the Scroll Lock feature.
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.
