How to Turn OFF Scroll Lock in Excel?

Tell me if this has happened to you – you’re working on an Excel spreadsheet, and as soon as you press any of the arrow keys, the entire page moves instead of moving the cursor to the next cell.

This happens because, somehow, the Scroll Lock has been enabled, and you need to turn off the scroll lock for things to work as expected in Excel.

In this short tutorial, I will show you a couple of methods to quickly turn off the Scroll Lock in Excel.

How to Know that Scroll Lock is Enabled?

Before I tell you how to turn off the scroll lock in Excel, I must tell you how to identify whether it is enabled or disabled.

If the scroll lock is turned on, you should be able to see the text Scroll Lock appear in the status bar in an Excel workbook (as shown below).

Scroll lock text written in the status bar

If you see the word ‘Scroll Lock’ in the status bar, you can be 100% sure that the scroll lock is enabled.

If you don’t see the word Scroll Lock in the status bar, right-click on the status bar and make sure the option Scroll Lock is checked.

Enable scroll lock in the status bar

If it is checked, and you still don’t see the word Scroll lock in the status bar, you can rest assured that Scroll Lock is turned off.

Note: Another reliable way to know that the scroll lock has been enabled is to try using the arrow key and see if the cursor moves. if instead of the cursor, you see the entire sheet moving, there’s a good chance that the scroll lock is turned on.

How to Turn Off Scroll in Excel (Windows)

Scroll lock is not an Excel thing – rather it’s an operating system thing (such as Windows or Mac)

So the process of turning off the scroll look in Excel would happen entirely outside of Excel.

Disable Scroll Lock Using the Keyboard

The easiest way to turn off the scroll lock in Excel is by using the scroll lock key on your keyboard.

Scroll Lock Button Keyboard
The Scroll Lock key on the Keyboard

If the layout of your keyboard is similar to the one shown above, the Scroll Lock key is likely to be in between the Print Screen key and the Pause/Break key.

In keyboards like these, you will also notice that there is a Scroll Lock light which would be turned green if the scroll lock is enabled, and it would be turned off if the scroll lock is disabled.

Scroll Lock Light
A green light appears when the scroll lock is enabled.

What if I Don’t have the Scroll Lock Key on my Keyboard?

If you’re using a laptop or a smaller keyboard, there’s a possibility that you may not have the scroll lock key on your keyboard.

For example, below is an image of my Dell laptop (that I’m currently using to write this article), and it does not have the scroll lock key

Dell keyboard layout

if you’re using a Dell keyboard, use the below shortcut to turn on or off the scroll lock in Excel:

Fn + S

Hold the function key and then press the S key.

For an HP laptop, you can use the below shortcut:

Fn + C

And if you can’t figure out the key combination in your keyboard, no worries. Use the method I cover next (which uses the on-screen keyboard to turn off the scroll lock)

Disable Scroll Lock Using the On-Screen Keyboard

Below are the steps to open the on-screen keyboard and turn off the scroll lock:

  1. Search for the On-screen keyboard in Windows
  2. Click on the On-screen app (this will open the on-screen keyboard on your system)
Search for On screen keyboard
  1. On the keyboard, click on the ScrLk key to turn it on or off
Scroll Lock key on onscreen keyboard

If the Scroll Lock is already enabled, you will notice that the ScrLk key appears in a slightly different shade of color.

And once the scroll lock has been turned off, the ScrLk key will be of the same color as that of other keys on the keyboard.

Also read: Arrow Keys not Working in Excel | Moving Pages Instead of Cells

How to Turn Off Scroll in Excel (Mac)

If you’re using Excel or Mac, you won’t see the scroll lock status in the status bar.

However, if you use your arrow keys and do not see the cursor moving (or you do not see the cell address change in the name box), you can safely assume that the scroll lock has been enabled.

With Extended Mac Keyboard

If you are using the extended mac keyboard (that has the numeric keypad), you can toggle the scroll lock setting by using the F14 key.

If you have the Function keys enabled on your system, you can press the F14 key to turn off or turn on the scroll lock.

Scroll Lock turn off with short mac keyboard

If the Fn keys are not enabled, you can use the fn + F14 key combination (hold the Fn key and press the F14 key).

And if there is no fn key on your keyboard, try using Shift + F14.

There is also a possibility that the settings in your system are different, and Shift + F14 doesn’t work. Try using the Command, Option, or Control key instead of the Shift key.

With Compact/Short Mac Keyboards

If you use a MacBook that does not have an extended keyboard, you will not have the F14 key.

In that case, you can use the below keyboard shortcut to turn on or off the scroll lock in Excel.

fn + Shift + F12
Scroll Lock turn off with short mac keyboard

So these are methods you can use to quickly enable or disable the crawl lock in Excel in Excel.

Since the settings and layout of keyboards in Windows and Mac are different, you will have to use different key combinations to toggle the scroll lock setting.

Other Excel articles you may also like:

Excel Ebook Subscribe

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Sumit Bansal
Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

1 thought on “How to Turn OFF Scroll Lock in Excel?”

Leave a Comment

Free-Excel-Tips-EBook-Sumit-Bansal-1.png

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Free-Excel-Tips-EBook-Sumit-Bansal-1.png

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Free Excel Tips EBook Sumit Bansal

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster