Durjoy Paul
Excel arrows scrolling not moving cells is a very frustrating problem to have. The arrows scrolling helps Excel users to move from one cell to another. But when users face arrows scrolling not moving cells problem, they find it really difficult to use Excel for bigger calculations. This article will focus on all the possible solutions to solve arrows scrolling not moving cells problems. I hope you will find it very useful for your day-to-day purpose.
Download Practice Workbook
Download this practice workbook
6 Possible Solutions for Excel Arrows Scrolling Not Moving Cells
Before showing any solution, you need to understand the problem carefully. The arrow scrolling helps to move the cells like the right arrow moving cell E5 to cell F5. But in some cases, this arrow scrolling doesn’t move from one cell to another. We are in the cell E5 in our worksheet
Now, if we press the right arrow on our keyboard, it will move the whole worksheet instead of cells. This is a very frustrating problem to have.
We have found six possible solutions through which we can easily solve this issue.
Solution 1: Turn Off Scroll Lock from On-Screen Keyboard
One of the main reasons for Excel arrows scrolling not moving cells is because of turning the scroll lock-on. You can’t get a proper arrow scrolling experience in your excel if you turn on the scroll lock on the keyboard. You can just turn off the scroll lock on the keyboard to solve the issue. If there is a case where you don’t have any scroll lock on your physical keyboard, you can turn off the scroll lock from your windows on-screen keyboard. To do this you need to follow the following steps
Steps
- First, go to the windows search option.
- From there, search On-Screen Keyboard.
- Click on the On-Screen Keyboard.
- It will appear like our physical keyboard.
- In the On-Screen Keyboard, turn off ScrLK which is the actual scroll lock in the On-Screen Keyboard.
- It will eventually disable the scroll lock.
Solution 2: Turn Off Scroll Lock from Status Bar
You can turn off the scroll lock in the Excel Status bar. By turning off the scroll lock in the Excel status bar, you can solve the arrow scrolling issue. Follow the steps carefully.
Steps
- First, open a new or existing worksheet.
- Right-click on it at the bottom of the worksheet to open the Status bar.
- From the Status bar, search the scroll lock option.
- If the scroll lock is on which is shown next to the scroll lock, then click on it to turn it off.
Then, check the arrow whether it scrolls properly or not.
Solution 3: Turn On Sticky Keys
Another useful solution can be found by checking on the sticky key feature. It will indirectly help the arrow scrolling issue. Many users find it really helpful in that case. Follow the following steps to check on the sticky key feature in our computer.
Steps
- First, open the windows search option by pressing Windows+S.
- Next, search the Control Panel.
- Then, click on the Control Panel.
- The Control Panel dialog box will appear.
- From there, select the Ease of Access option.
- Next, from the Ease of Access Center, select Change how your keyboard works.
- Then, Make the keyboard easier to use dialog box will appear.
- Next, in the Make it easier to type section, check the Turn on Sticky Keys.
- Finally, click on Apply.
Now, close the Control Panel. Then, check whether your Excel arrows scrolling works well or not.
Similar Readings
- How to Stop Excel from Scrolling to Infinity (7 Effective Methods)
- [Solved!] Vertical Scroll Not Working in Excel (9 Quick Solutions)
- Horizontal Scroll Not Working in Excel (6 Possible Solutions)
- Stop Excel from Jumping Cells When Scrolling (8 Easy Methods)
- How to Repeat Rows in Excel When Scrolling (6 Suitable Ways)
Solution 4: Disable Excel Add-ins
Sometimes, Excel Add-ins can cause some problems in your Excel worksheet. When you check on the add-ins, it tries to add some new codes to the application. This actually changes some original features. To solve this problem you need to uncheck all the Excel add-ins and check whether it solves our purposes. Follow the steps to disable all Excel add-ins
Steps
- First, go to the File tab in the ribbon.
- In the File tab, select the More command.
- From there, select Options.
- Excel Options dialog box will appear.
- Next, select the Add-ins.
- In the Add-ins section, there is a Manage option, select Excel Add-ins from there.
- Then, click on Go.
- Add-ins dialog box will pop up.
- In the Add-ins Available section, uncheck all the available add-ins.
- Finally, click on OK.
Now, check the Excel arrows scrolling whether they work or not.
Read More: Excel Not Scrolling with Arrow Keys (4 Suitable Solutions)
Solution 5: Unfreeze Rows or Columns
There are some cases where you need to freeze your rows and columns. But after that, you forget that you do freeze your rows and columns. In a freeze situation, your arrow won’t scroll properly. You need to check whether you unfreeze all the rows and columns and then use the arrow.
Read More: How to Unlock Cells in Excel When Scrolling (4 Easy Ways)
Solution 6: Exit Formula Entry Mode
Another unwanted issue can appear when you are in the formula entry mode. When you enter ‘=’ in any cell, it will appear formula entry mode. If you press the arrow key at that time, it will change the cell as a function in the formula entry mode. But, this arrow can’t control your whole worksheet. To exit formula entry mode, use backspace and delete all the values including the ‘=’ sign. After that, check the arrow whether it scrolls perfectly or not.
Conclusion
We have discussed six different solutions to solve the Excel arrows scrolling not moving cells issue. All the methods are equally useful and fairly easy to digest. You may need one of them to solve the whole issue but you can go through all of them because in the future it can solve some other issues also. If you have any questions, feel free to ask in the comment box, and don’t forget to visit our ExcelDemy page.
Related Articles
- How to Scroll One Row at a Time in Excel (4 Quick Ways)
- Smooth Scrolling with Mouse Wheel in Excel (A Detailed Analysis)
- How to Stop Arrow Keys from Scrolling in Excel (3 Easy Methods)
- Lock Rows in Excel When Scrolling (4 Easy Methods)
- How to Lock Cells in Excel When Scrolling (2 Easy Ways)
- Viewing and Scrolling Multiple Excel Workbooks at the Same Time
