QueHow

A How-To and wiki Blog

  • Operating System
    • Windows
      • Windows 10
      • Windows 7
    • Linux
  • Software
    • Application Software
    • Microsoft Office
      • Outlook
      • Word
      • PowerPoint
  • Internet
    • Browsers
      • Mozilla Firefox
      • Google Chrome
    • CMS
    • Tips & Tricks
  • Website
    • ecommerce
    • Google
    • Social Networking
    • General Websites
  • Mobile
  • Email
    • Gmail
  • Wiki

How to Enable and Disable Scroll Lock in Excel?

By Neha T Leave a Comment

A scroll lock is a function that determines the action of arrow keys present on your keyboard when you are working in Excel. You might have experienced that sometimes pressing the arrow keys moves the entire excel sheet instead of moving the cursor to the next cell.

You can easily enable and disable the scroll lock feature. But before moving to the steps let us first know more about the scroll lock feature in the spreadsheet.

What is Scroll Lock in Excel?

Scroll lock is a feature that decides the function of the arrow key in excel. You can easily enable and disable this feature as per your convenience. By default, the scroll lock feature is disabled.

  1. In the disabled state, if you press the arrow keys of your keyboard, it will allow you to navigate the cells of your excel worksheet.
  2. In the enabled state, the arrow keys act differently and it doesn’t allow you to navigate to different cells of your worksheet instead it scrolls the entire worksheet.

The excel users like to work with scroll lock disabled. In some cases, the user accidentally enables this feature. Knowing the scroll lock feature let us now discuss the steps to enable and disable it.

Steps to Enable and Disable Scroll Lock in Excel:

Enable Scroll Lock

Step 1: To enable the scroll lock you just have to press the “Scroll Lock” button present on your keyword.

Enable and Disable Scroll Lock in Excel - 01

Or

Step 1: In case your keyboard doesn’t have a scroll lock button then you can enable the “On-Screen Keyboard”. To enable the on-screen keyboard, click:

Start>Settings>Ease of Access> Keyboard

Step 2: Here you have to switch on the “Use the On-Screen Keyboard” toggle button.

Enable and Disable Scroll Lock in Excel - 02

Step 3: When your On-Screen keyboard appears just click on the “ScrLK” button.

Enable and Disable Scroll Lock in Excel - 03

Disable Scroll Lock

Step 1: To disable the scroll lock, we just have to press the “Scroll Lock” button again on the keyboard.

Scroll Lock on Status Bar

Well, the spreadsheet does not exclusively show whether the scroll lock is on or off.

To show the status of scroll lock on the sheet ‘right click’ on the status bar of the spreadsheet. From the displayed menu click on the ‘Scroll Lock‘.


Enable and Disable Scroll Lock in Excel - 4

This will let the scroll lock appear on the excel sheet’s status bar. So when the scroll lock is enabled it will appear on the status bar and when it is disabled it doesn’t appear on the status bar.

Enable and Disable Scroll Lock in Excel - 04

So, this is how you can enable and disable scroll lock in Excel.

You Might Also Like:

Lock Formulas or a Cell in Excel - feature ImageHow to Lock Formulas or Cells in Excel? How to Enable / Disable Virtual Keyboard in windows 7 Enable-Disable-Virtual-Keyboard-in-Windows-10-feature-imageHow to Enable /Disable Virtual Keyboard in Windows 10? how-to-lock-screen-in-windows-10How to Lock Screen in Windows 10? How to Enable & Disable Chat in Gmail? enable macro featured imageHow to Enable Macros in Excel 2016? How to enable and configure gmail keyboard shortcuts Enable Disable Registry Editor-featureimageHow to Enable & Disable Registry Editor in Windows 10?

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Most Viewed

  • How to Install and Use TELNET in Ubuntu
  • How to install Hindi fonts in MS Word
  • How to Change a File Extension in Windows 10?
  • How to create a flipkart account in 3 simple steps
  • How to Change Monitor Refresh Rate in Windows 10?
  • How to install IIS on Windows 10
  • How to Insert Clickable Checkbox in MS Word 2016?
  • How to Set Auto Reply in Outlook 2016?
  • How to Login as Administrator in Windows 10?
  • How to Check RAM Size and System Type in Windows 10?

Recent Additions

  • How to Add Hyperlink to Another Sheet in Excel?
  • How to Add and Remove Watermark in Excel
  • How to use Relative and Absolute Cell Reference in Excel?
  • How to Enable and Disable Scroll Lock in Excel?
  • How to Use INDEX and MATCH Functions in Excel?
  • How to Make Bar Graph in Excel?
  • How to Count Duplicate Values in Excel?
  • How to Wrap Text in Excel?
  • How to Round off Numbers in Excel?
  • How to Create a Bell Curve in Excel?

Related Searches

  • How to Mute Someone’s Stories or Posts on Instagram?
  • How to change login screen using tweak tool in Ubuntu 14.04
  • How to Remember Password in Firefox?
  • How to Change OneDrive Location?
  • How to Tag Someone on Instagram Post?

Copyright © 2023 · QueHow · Contact Us