Turn ON or Turn OFF scroll lock in Excel

Turn ON/ Turn OFF Scroll Lock in Excel

Imagine your report is due in an hour. You are working along in Excel, everything is going well, but suddenly you notice that you can no longer move around properly in your spreadsheet. You press the arrow keys, but instead of the cursor moving to another cell, the entire worksheet seems to be moving.

What happened? Solution: Don’t panic, relax! Because it is an issue of Scroll Lock. Let’s see how to solve this problem.

Before we learn how to enable or disable scroll lock in Excel, we must learn what is scroll lock?

how to use scroll lock in excel

What is Scroll Lock in Excel?

The Scroll Lock is a setting that determines what happens when you use the Arrow Keys on your keyboard in Excel. When Scroll Lock is off (It is a default setting), the Arrow Keys allow you to navigate and select different cells within a worksheet. In another case when Scroll Lock is enabled, the Arrow Keys will instead “scroll” through the active window. You will not be able to navigate to different cells (using the Arrow Keys of the keyboard), instead, you will only be able to change the viewing area, similar to clicking the arrows on the ScrollBars. In the picture given below, we can see the evil “Scroll Lock” is visible in the status bar of Excel Program.

how to enable scroll lock in excel

There are times when you may want Scroll Lock enabled, though in general, most Excel users only activate this feature by accident.

Read More: Learn how to merge excel files using a macro

Now let’s walk through the process of enabling and disabling the scroll lock.

➡  Step to Turn Off Scroll Lock in Excel:

  • Imagine that Scroll Lock is enabled and it is visible in the status bar.
  • Now we need to disable it. Right click on the Status Bar of Excel Window.

➡ In the Pop-up Menu Scroll Lock is checked and showing On. How to enable disable scroll lock in excel Turn OFF Scroll Lock in Excel

After you uncheck it, the Scroll Lock would not be visible on the Status Bar as shown in the picture below.

disable scroll lock Now Scroll Lock is disabled and the Arrow Keys allow us to navigate and select different cells within this worksheet.

Read More: How to use VLOOKUP Formula with Example

➡ Scroll Lock is still ON?

After the above processes if your Scroll Lock is still enabled, then you need to Off Scroll lock from your Key Board. In Key Board Scroll Lock is visible as “ScrLk”. This key works similar to a “caps lock” key.

Press “ScrLk” key to Off Scroll Lock. Now Scroll lock is disabled from excel sheet. Don’t have “ScrLk” key in Key Board? Don’t Worry. If you don’t have “ScrLk” key on your keyboard, then you can use the on-screen keyboard from your windows by doing one of the following steps based on your windows:

How to turn off scroll lock using keyboard

Case Study 1: For Windows 10 (Scroll Lock Excel)

  • Click Start >Settings>Ease of Access>Keyboard.
  • Click the On-Screen Keyboard button to turn it on.
  • When the on-screen keyboard appears on your screen, click theScrLk” button.

scroll lock in excel

 Case Study 2: For Windows 8.1

  • Click start and then press CTRL+C to display the Charms bar.
  • Click Change PC Settings.
  • Select Ease of Access>Keyboard.
  • Click the On Screen Keyboard slider button to turn it on.
  • When the on-screen keyboard appears on your screen, click theScrLk” button.

scroll lock position

Case Study 3: For Windows 7

  • Start>All Programs>Accessories>Ease of Access>On-Screen Keyboard.
  • When the on-screen keyboard appears on your screen, click theslk” button.



3 Responses

Leave a Reply

Pre-Registration Open

Power BI Dax

Related Tutorials

Text To Column in Excel | Split Cells
January 4, 2019
Pivot Tables (Complete Guidelines)
December 27, 2018
Power Bi Dax Deduplication Based On Column
December 17, 2018
Special Character Symbol List with Shortcodes in Excel
December 15, 2018
December 10, 2018
December 10, 2018
How to use ABS Function in Excel
December 10, 2018
How to use AND Function in Excel
December 10, 2018
Delete Duplicate in Excel or Remove Duplicate in Excel
November 9, 2018
Excel Formulas PDF
September 6, 2018
How To Lock Cells in Excel | Unprotect Excel
August 13, 2018
4x Faster at Excel
August 6, 2018
Separate Content of One Excel Cells into Separate Columns
August 3, 2018
How to Transpose Excel Columns to Rows | Paste Special Method
July 26, 2018
How to create sparklines in Excel
July 19, 2018
AutoSum in Excel with Shortcut
July 17, 2018
OFFSET Function in Excel
July 6, 2018
Strikethrough Shortcut in Excel & Word
July 4, 2018
INDIRECT Function with SUM, MAX, MIN & Independent Cell Value
June 29, 2018
Pivot Table Slicers In Excel
June 12, 2018
How to Wrap Text in Excel Automatically and Manually
June 6, 2018
How to Hide/Unhide Column in Excel
June 5, 2018
Highlight row based on cell value
June 4, 2018
Learn how to remove blank cells in Excel
June 3, 2018
How to Group Numbers, Dates & Text in Pivot table in Excel
June 1, 2018