Whereas Microsoft Excel is a robust software, understanding its interface and discovering varied settings and choices may be difficult, particularly for newcomers. In case you’re in the same place trying to flip off scroll lock in Excel, we’re right here to assist.

On this article, we wish to present you how one can disable the scroll lock in Microsoft Excel. We’ll additionally aid you reinstate the scroll bar whether it is lacking out of your spreadsheet. However what does scroll lock even do on Excel? How do I do know whether it is turned on? Let’s discover out.

Scroll Lock on Excel impacts the best way you scroll by way of a spreadsheet. When enabled, you possibly can navigate the spreadsheet with out altering the lively cell (the presently chosen cell).

As an alternative of shifting the lively cell, the arrow keys will scroll the complete sheet up, down, left, or proper. Additional, the mouse wheel may even scroll the sheet, permitting you to navigate the rows or columns with out altering the lively cell.

Methods to Verify if Scroll Lock Is Enabled on Excel

In case you’re not sure whether or not scroll lock is enabled on Excel, look on the standing bar within the backside nook of the spreadsheet. You’ll see a sign that claims ‘Scroll Lock’.

In case you don’t see it, right-click on the standing bar. Verify if it says ‘on’ subsequent to Scroll Lock within the record of choices.

Make sure you verify the Scroll Lock possibility on this record in order that there’s a sign within the standing bar whether it is enabled.

Listed here are 3 ways to show off the scroll lock in Microsoft Excel. Let’s start.

1. Disable the Scroll Lock Utilizing the Keyboard Shortcut

In case you observe carefully, you’ll discover that your Home windows keyboard has a Scroll Lock key. While you use this key, it disables the scroll lock within the open software. Subsequently, you should use this key to disable the scroll lock on Microsoft Excel.

On Mac: You should utilize the important thing mixture fn + Shift + F12 to show the scroll lock performance on or off.

2. Disable Scroll Lock Utilizing On-Display Keyboard (Home windows)

In case you don’t discover the Scroll Lock key in your keyboard, don’t fear. There may be another technique to do the identical.

Home windows has an on-screen keyboard possibility that gives a digital set of keys you should use in your show. This keyboard has the scroll lock key, and you should use it to show off the scroll lock whereas Excel is open.

Open the On-Display Keyboard app from the beginning menu. You’ll be able to search for a similar utilizing the search bar.

When you open it, you should use the ScrlLk key to show it off on Excel.

3. Flip Off Scroll Lock Utilizing VBA (Home windows)

Alternatively, you possibly can run a macro to show off the scroll lock. Right here’s how you are able to do it.

Step 1: Use Alt + F11 in Home windows, or Choice + F11 in Mac to open the VBA editor on Microsoft Excel.

Step 2: Within the VBA editor, click on on the Insert tab and select Module to insert a brand new module.

Step 4: Copy and paste the next code into the module:

Sub TurnOffScrollLock()
    Utility.SendKeys "{SCROLLLOCK}"
Finish Sub

Step 5: Shut the VBA editor.

Step 6: Press Alt + F8 in Home windows, or Choice + F8 in Mac. Choose TurnOffScrollLock, and click on Run to run the macro.

That’s how one can flip off the scroll lock on Microsoft Excel. When you have any additional questions, take a look at the FAQ part beneath.