How To Lock and Unlock the Scroll Lock in Excel?


The Scroll Lock function in Excel lets you shortly alter how one can navigate your Excel workbooks. However do you know that you may lock and unlock the scroll function in Excel? 

This put up will present you ways.

lock and unlock the scroll feature in excel
By default, the arrow keys in your keyboard will make it easier to navigate Excel cells one by one, in any path you want to transfer in. This may be modified right away by enabling Scroll Lock. When it’s enabled in Excel, the cells can be chosen by shifting your scroll wheel, versus utilizing the arrow keys.

Much like Caps Lock and Num Lock, this function must be turned on and off utilizing a key in your keyboard. Don’t fear, we’re right here to assist.

Tips on how to Allow and disable Scroll Lock in Microsoft Excel

The guides beneath have been written utilizing the most recent Microsoft Excel 2019 for Home windows 10. Should you’re utilizing a special model or platform, some steps could range. Contact our specialists for those who want any additional help.

1. Tips on how to toggle Scroll Lock in Excel

You may simply toggle this Excel function through the use of your laptop’s keyboard. Most keyboards could have a button devoted to Scroll Lock, usually abbreviated to “ScrLk”. When the Excel utility window is lively, press this button on the keyboard to allow or disable Scroll Lock.

Moreover, chances are you’ll use the on-screen keyboard to toggle Scroll Lock on and off in Excel.

  1. Click on on the Begin menu in your taskbar (Home windows icon) and select Settings. Alternatively, you should utilize the Home windows + I keyboard shortcut.
    Windows start Settings
  2. Click on on the Ease of Entry tile. Right here is the place you may see all of Home windows 10’s accessibility options.
    Windows ease of access
  3. Scroll down within the left-side panel, then click on on the Keyboard listed underneath the Interplay part. Click on on the toggle underneath Use the On-Display screen Keyboard to activate the digital keyboard in Home windows 10.
  4. Now, you’ll be capable of use the ScrLk key to toggle Excel’s Scroll Lock function on and off at any time, even when your laptop is lacking the bodily key.

2. Tips on how to allow and disable Scroll Lock in Excel

There’s one other solution to shortly allow or disable the Scroll lock function when working in Excel. 

  1. Open Microsoft Excel and cargo any workbook. You might also create a brand new workbook for the needs of enabling or disabling Scroll Lock.
  2. Look within the backside left nook of the Excel window and make sure that Scroll Lock is both turned on or turned off.
    enable and siable scroll lock
  3. Proper-click wherever within the backside menu bar, after which choose Scroll Lock from the context menu. By clicking on it, the function will grow to be both enabled or disabled with out having to make use of the keyboard shortcut.
    enable and diable scrol lock
  4. Voila! You are one! Now, you may shortly swap between two methods of navigating your Excel information.

Remaining ideas

We hope this text helped you discover ways to allow and disable the Scroll Lock function in Microsoft Excel. Begin navigating your workbooks like a professional and save treasured seconds when enhancing your worksheets.

Earlier than you go

Should you want any additional assist with Excel, don’t hesitate to achieve out to our customer support staff, out there 24/7 to help you. Return to us for extra informative articles all associated to productiveness and modern-day expertise!

Would you wish to obtain promotions, offers, and reductions to get our merchandise for one of the best price? Don’t overlook to subscribe to our publication by getting into your electronic mail tackle beneath! Obtain the most recent expertise information in your inbox and be the primary to learn our tricks to grow to be extra productive.

You might also like

» How To Group Worksheets in Excel
» 13 Excel Suggestions and Methods to Make You Right into a Professional
» How Do You Insert Line Break in Excel?

NOTE : Please do not copy -
See also  Fix Unable to install printer. Another printer or printer with this name already exists

Leave a Reply