Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Stop Arrow Keys from Scrolling in Excel (3 Easy Methods)

In this article, we are going to show the top 3 solutions of how to stop Arrow keys from scrolling in Excel. We will demonstrate our methods using a dataset, which contains Employee Names, and their car information. To be more specific our dataset has 3 columns: “Name”, “Car Model”, and “Car Maker”.

How to Stop Arrow Keys from Scrolling in Excel


Download Practice Workbook


Why Arrow Keys Scroll in Excel?

Normally the Arrow keys move our Cursor. However, there are two scenarios where this will not be true.

  • First, if we turn on SCROLL LOCK then, the Arrow keys will not move the Cursor, rather it will scroll our dataset. To solve this problem, we will need to turn off the scroll lock.
  • The other reason is when we have Add-ins. Many Add-ins will make the Arrow keys scroll in Excel. To get rid of this problem, we will need to disable or remove the Add-ins from Excel.

Now that we know what mainly causes this problem, let’s jump right into the solutions section. However, we will only show the solutions to the first problem, if that does not solve your scrolling problem, then you will need to remove or disable Add-ins.


3 Ways to Stop Arrow Keys from Scrolling in Excel

1. Using Hardware Keyboard Scroll Lock Key to Stop Arrow Keys from Scrolling

In this section, we are going to show you the first method of stopping Arrow keys from scrolling. We have already discussed the two main reasons for this issue. Let us demonstrate the problem.

This is our dataset. If we use the Arrow keys, our cursor will move from one cell to another and this is the default behavior in Excel.

Using Hardware Keyboard Scroll Lock Key to Stop Arrow Keys from Scrolling

However, if we turn on the “Scroll Lock” button, then we’ll not be able to move from one cell to another. Moreover, we will see “Scroll Lock” on the Status Bar. This means our “Scroll Lock” button is on. Therefore, we need to turn off this. To do that –

Steps:

  • First, press the SCROLL LOCK button on the Keyboard.

Then, we will see the “Scroll Lock” is not there anymore on the Status Bar.

Using Hardware Keyboard Scroll Lock Key to Stop Arrow Keys from Scrolling

Now, if we move the mouse cursor with the Arrow keys, then we will see the scrolling in Excel is no more the problem. Thus, we have finished the first solution to our issue.

Read More: Excel Not Scrolling with Arrow Keys (4 Suitable Solutions)


2. Use of On-Screen Keyboard to Stop Arrow Keys from Scrolling

For the second method, we will use the On-Screen Keyboard to stop the Arrow keys from scrolling in Excel. As there are many Keyboard layouts (60%, 75%, TKL, Full Size, etc.), not all of them have the “Scroll Lock” key. Therefore, this method will be handy for those smaller form factors.

Steps:

  • First, we can see the Status Bar is reflecting that our Arrow keys will scroll in our dataset.

Use of On-Screen Keyboard to Stop Arrow Keys from Scrolling

  • Secondly, press the Windows Key + R.

This will bring up the Run dialog box.

  • Thirdly, type “osk” inside the Open box.
  • Then, press OK.

We will notice that the On-Screen Keyboard has been opened.

  • Finally, click on the “ScrLk” button on the On-Screen Keyboard.

How to Stop Arrow Keys from Scrolling in Excel using On-Screen Keyboard

Thus, this will stop the Arrow keys from scrolling in Excel. Moreover, as we pressed the Down Arrow key, our cursor moved from cell B5 to cell B6.

Read More: How to Get Rid of Plus Sign Cursor in Excel (2 Effective Methods)


Similar Readings


3. Stop Arrow Keys from Scrolling by Applying VBA

For the last method, we are going to use Excel VBA to stop Arrow keys from scrolling. Basically, we will be using the SendKeys method to achieve our goal. Moreover, we can see that the “Scroll Lock is turned on” in our Sheet.

Stop Arrow Keys from Scrolling by Applying VBA

Steps:

  • First, from the Developer tab >>> select Visual Basic.

This will bring up the Visual Basic window.

  • Secondly, from Insert >>> select Module.

Here, we will write our code.

Stop Arrow Keys from Scrolling by Applying VBA: Insert Code Module

  • Thirdly, type the following code.
Sub Turn_Off_Scrolling()
Application.SendKeys "{SCROLLLOCK}"
End Sub

VBA Code Breakdown

  • First, we are calling our Sub Procedure Turn_Off_Scrolling.
  • Secondly, we are using the SendKeys method to input a Keyboard button.
  • Finally, we have defined “Scroll Lock” as our button to send.

Thus, this code works to turn off Scrolling in Excel.

  • Then, Save the code.
  • After that, put the cursor inside the code and press Run.

Stop Arrow Keys from Scrolling by Applying VBA: Run Code

  • Finally, close this window.

This will execute our code as described in the VBA code breakdown section. In conclusion, it will stop the Arrow keys from scrolling and if we press the Right Arrow key then our cursor will move from cell B5 to B6.

Read More: How to Stop Excel from Jumping Cells When Scrolling (8 Easy Methods)


Conclusion

We have shown you 3 quick methods of how to stop Arrow keys from scrolling in Excel. If you face any problems, feel free to comment below. Moreover, you can visit Exceldemy for more Excel-related articles. Thanks for reading, keep excelling!


Related Articles

Rafiul Haq

Rafiul Haq

Hello! This is Rafiul. I have an engineering degree and an MBA (finance) degree. I am passionate about all things related to data, and MS Excel is my favorite application. I want to make people's lives easier by writing easy-to-follow and in-depth Excel and finance related guides here at ExcelDemy.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo