How to Fix Excel Not Scrolling with Arrow Keys (4 Solutions)

1 – When the Enabled Scroll Lock Feature in Excel Prevents Scrolling with Arrow Keys

1.1 Turning Off Scroll Lock from External Keyboard

 

We can turn off the Scroll Lock from the keyboard. You will find a button named the Scroll Lock beside the function keys at the top side of the keyboard.

Since Scroll Lock is enabled, a notification light has been turned on. Now, press the Scroll Lock button and notice that the light is turned off. It means scrolling with arrow keys is enabled again, and you can scroll through them.

Turn Off from Keyboard in Excel


1.2 Using the On-Screen Keyboard to Disable Scroll Lock

Steps:

  • Go to the Windows Search bar at the bottom left of the screen. If you can’t find it, press Win+S.
  • The search box window will appear.
  • Enter On Screen in the Search bar.
  • The On-Screen Keyboard app will appear. Click on that app icon.

  • The On-Screen Keyboard appears.
  • ScrLk is marked/highlighted. That means the Scroll Lock is turned on.
  • Click on that button to disable the Scroll Lock feature.

Using On-Screen Keyboard to enable scrolling in Excel

Now, we will be able to scroll with the arrow keys.


2 – When Excel is Not Scrolling with Arrow Keys Due to Deactivated Sticky Keys

Steps:

  • Enter Control Panel in the Search box at the bottom left corner of the screen.
  • Click on the control panel icon.

  • Select the Ease of Access option from the Control Panel window.

Turn on Sticky Keys to solve not scrolling in Excel

  • Choose Change how your keyboard works from the Ease of Access modifier window.

  • We get a new window. Find the Make it easier to type option from that window.
  • Check on the Turn on Sticky Keys option.

Turn on Sticky Keys to solve not scrolling in Excel

Another alternative way to enable Sticky Keys is to press Shift key 5 and then click Yes in the pop-up box.

Turn on Sticky Keys to solve not scrolling in Excel


3 – When Some Excel Add-Ins Block Scrolling with Arrow Keys

Steps:

  • Go to File >> Options from the worksheet file.
  • Click Add-ins from the right side of the Excel Options window.
  • We get the navigation panel on the left side.
  • Check Manage has been selected as the Excel Add-ins option.
  • Click on Go.

Disable Add-Ins to active scrolling in Excel

  • Unmark all the Add-ins and then press OK.

Disable Add-Ins to active scrolling in Excel

  • If scrolling starts working with the arrow keys, check each Add-in one by one and identify the problematic Add-in.

  • Ddisable that Add-in.

4 – When Freezed Columns or Rows in the Worksheet Results in Excel Not Scrolling with Arrow Keys

If we freeze a group of columns or rows, it looks like scrolling is not working. Our cursor moves through those frozen rows or columns as we freeze those cells. It looks like that arrow key is unable to scroll. So first, we need to unfreeze those columns or rows, and then we can scroll throughout the whole worksheet.

Read More: How to Stop Excel from Scrolling to Infinity 


Related Articles


<< Go Back to Scrolling in Excel | Navigation in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Alok Paul
Alok Paul

Alok Paul has completed his B.Sc. in Electronics and Telecommunication Engineering from East West University. He has been working on the ExcelDemy project for more than 2 years. He has written 220+ articles and replied to numerous comments. He is experienced in Microsoft Office, especially in Excel. He also led some teams on Excel and VBA content development. He has a keen interest in Advanced Excel, Data analysis, Excel Pivot Table, Charts, and Dashboard. He loves to research... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo