How to Use the Arrows to Move Screen Not Cell in Excel (4 Methods)

Sometimes in Excel, we like to use the 4 arrow keys to move between cells if we are working with a large worksheet with a lot of columns and rows. Activating the scroll lock feature is one of the efficient ways to use arrows to move between cells. While some users might find it very effective to have the scroll lock feature enabled, others might find it quite annoying who have activated this feature mistakenly and now can not use the arrow keys to move between cells. In this tutorial, I will show you how to deactivate the scroll lock feature so you can use the arrows to move screen not cell in Excel.


Download Practice Workbook

Download this practice book to exercise the task while you are reading this article.


4 Suitable Methods to Use Arrows to Move Screen Not Cell

Let’s assume a scenario where we have an Excel file that contains information about the employees of a company. The worksheet has the Name, Age, Gender, Date of Birth, and the State each of them comes from. The problem is that this worksheet has the Scroll-lock enabled or on. As a result, instead of moving between cells, the arrow keys are now moving the entire worksheet or screen due to this feature. We will now disable the Scroll-lock feature of this worksheet to enable the arrow keys to move between cells. The image below shows the worksheet with the Scroll-lock feature enabled.

Note: However, if you do not know in the first place how to enable the scroll-lock feature in Excel or how you can effectively move between cells using this feature, please read this article to learn how to use this feature.

excel arrows move screen not cell


1. Turn Off the Scroll Lock Using the On-Screen Keyboard to Move Cell in Excel

We can use the On-Screen keyboard to turn off the Screen Lock in our worksheet. Just follow the below steps.

Step 1:

  • First, you have to open the On-Screen Keyboard by pressing the Windows logo key excel arrows move screen not cell+ CTRL + O to turn on the On-Screen Keyboard.
  • Alternatively, you can also turn on the On-Screen Keyboard from the Settings option. For that, you have to click on the Start menu of Windows from the taskbar and then select the Settings option from the menu bar that will appear.

Excel Arrows Move Screen Not Cell

  • Another way to open the Settings option is to click on the Search option from the taskbar and then type Settings on the Search.
  • You can then click on the Settings option from the search list.

Turn Off the Scroll Lock Using the On-Screen Keyboard

Step 2:

  • Now, a new window will appear with different types of Settings. Then, we will click on the Ease of Access on the rightmost side of the window.

Excel Arrows Move Screen Not Cell

  • Now, another window will now appear. We will scroll down the menu bar on the left side of that window. We will then select Keyboard under the Interaction.

Turn Off the Scroll Lock Using the On-Screen Keyboard

Step 3:

  • A new window with different options to manage the keyboard will appear. We will see a toggle button titled Use the On-Screen Keyboard. By default, it is set to Off. We will toggle the button from Off to On.

Excel Arrows Move Screen Not Cell

  • The On-Screen Keyboard will appear on the screen. We will see that the ScrLk key is turned on in our On-Screen Keyboard as indicated by the key being filled with light blue.
  • So, we will click on the key to turn it off.

Turn Off the Scroll Lock Using the On-Screen Keyboard

  • Now, we will see that the key is no longer filled with light blue. That means the ScrLk is turned off.

Excel Arrows Move Screen Not Cell

  • Another very easy way to turn on the On-Screen Keyboard is to the Run command of the Windows. Press Windows key + R to open the Run.
  • Now, the Run window with an input box will appear. We will type OSK.EXE in the input box.
  • We will then click on the OK An On-Screen Keyboard will appear.

Turn Off the Scroll Lock Using the On-Screen KeyboardStep 4:

Excel Arrows Move Screen Not Cell

  • If we now go back to our Excel worksheet, we will see that it does not have the Scroll Lock option anymore. We can also now move the cells instead of the worksheet or screen using the arrow keys on our keyboard.

Excel Arrows Move Screen Not Cell

Read More: [Fixed!] Unable to Move Cells in Excel (5 Solutions)


2. Turn Off the Scroll Lock From the Keyboard to Move Cell in Excel

Step 1:

Most of the keyboards on the laptop nowadays do not have a Scroll Lock key on them. But sometimes you might find one on a few models. Also the external keyboards most of the time come with a Scroll Lock key on them. The image below shows the Scroll Lock key on an external keyboard. You can press this key turn the Scroll Lock key On and Off.

Turn Off the Scroll Lock From the Keyboard

Step 2:

  • Some laptops have a shortcut key assigned to the Scroll Lock. For example, you can use the Fn+S to enable the Scroll Lock feature in Dell laptops.
  • On an HP laptop, you can press Fn+C to activate the Scroll Lock.

Read More: How to Move Cells without Replacing in Excel (3 Methods)


Similar Readings


3. Turn On the Sticky Key From the Keyboard

Disabling the Screen Lock key should solve the problem in most cases. But even after turning off the Screen Lock key does not solve the problem, then you could turn on the STICKY KEYS if that solves the problem.

Steps:

  • First, go to Settings>Ease of Access>Keyboard like Method 1
  • Then, toggle the Use Sticky Keys button to On like the image below.

Excel Arrows Move Screen Not Cell

Note: Enabling the STICKY keys will let you press shortcut keys one at a time rather than pressing them simultaneously. For example, instead of pressing the Windows key Windows Logo+ CTRL + O all at once to turn on the On-Screen Keyboard, you can press one key at a time and the On-Screen Keyboard will still open.

Read More: How to Shift Cells Up in Excel (5 Quick Ways)


4. Disable the Installed Add-Ins

Sometimes the Add-Ins we have installed might interfere with Excel. That might also disrupt the arrows keys function. In such a case, we have to disable the Add-Ins to see if that solves the problem with the arrow keys.

Step 1:

  • First, click on the File tab on the left of the Home tab.

Disable the Installed Add-Ins

  • Now, a new window will open. Click on the Options like the image below.

Excel Arrows Move Screen Not Cell

Step 2:

  • Another window titled Excel Options will appear. Now, we will click on the Add-ins.
  • Then we will click on the Go button just like the image below.

Disable the Installed Add-Ins

Step 3:

  • We will then deselect or tick off all the Add-Ins available.
  • Finally, we will click on the OK.

Excel Arrows Move Screen Not Cell

Read More: Move and Size with Cells in Excel (3 Examples)


Things to Remember

  • When SCROLL LOCK is on, Scroll Lock is displayed on the status bar in Excel.
  • To use the ARROW KEYs to shift between cells, you must turn SCROLL KEY.
  • Also if you want to use the ARROW KEYs to toggle between cells, you must turn SCROLL KEY To do that, press the Scroll Lock key. This key is labeled as ScLk on the keyboard.

Conclusion

In this article, we have learned to. Along with that, we also learn to use the arrows to move screen not cell in Excel. I hope from now on you can use the arrows to move screen not cell in Excel very easily. However, if you have any queries or recommendations about this article, please do leave a comment below. Have a great day!!!


Related Articles

ASM Arman

ASM Arman

Hi there! I am ASM Arman. I Completed B.Sc. in Naval Architecture and Marine Engineering. I take a great interest in learning about new technologies and sharing my ideas and thoughts on them with others. Please do reach out to me if you have any queries or recommendations. Have a great day!!!

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo