If you are looking for some special tricks to stop Excel from jumping cells when scrolling, you’ve come to the right place. There are numerous ways to stop Excel from jumping cells when scrolling. This article will discuss eight methods to stop Excel from jumping cells when scrolling. Let’s follow the complete guide to learn all of this.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
8 Suitable Methods to Stop Excel from Jumping Cells When Scrolling
We will use eight effective and tricky methods to stop Excel from jumping cells when scrolling. This section provides extensive details on eight methods. You should learn and apply all of these, as they improve your thinking capability and Excel knowledge
1. Changing Mouse Settings
It is the fastest and quickest method of solving the problem. To stop Excel from jumping cells when scrolling, you have to use the control panel. To do this we have to follow the following steps.
- First of all, go to Control Panel. Then, select Choose mouse settings.
- When the Mouse Properties window appears, then select Wheel. Then, enter 1 in The following number of lines at a time section.
This method will help you to stop Excel from jumping cells while scrolling.
Read More: Smooth Scrolling with Mouse Wheel in Excel (A Detailed Analysis)
2. Using Scroll Lock Key on Keyboard
Sometimes for some unknown reason enabling the mouse settings feature will not solve the problem. In this case, you have to use a hardware keyboard scroll lock to solve the problem. To do this we have to press the Scroll Lock button on the Keyboard. It is common for a computer keyboard to have a Scroll key; if the light for the key is on, it means it is on. The key can be turned off by pressing it just once. When you turn off the light of the button, you are also turning off Scroll Lock.
Read More: How to Lock Cells in Excel When Scrolling (2 Easy Ways)
3. Utilizing On-Screen Keyboard
In modern computers and laptops, scroll locks are rarely found. Due to the belief that consumers seldom use this key, it has been removed from the latest models of PCs and laptops. On-screen keyboards enable you to access all the keys, including those that aren’t accessible from a physical keyboard. If any of the keys on the physical keyboard are damaged or do not work, you can also use the on-screen keyboard. We can also stop Excel from jumping cells while scrolling by using the on-screen Scroll Lock. To do this you have to follow the following process. Let’s walk through the steps to find out how to turn off the Scroll Lock key.
- Firstly, press the ‘Win+R’ keys to access the Run command on your keyboard.
- Next, type OSK.EXE in the search field and click on OK.
- When the On-screen keyboard appears, you will see that the ScrLk button is blue, which means it is enabled. To turn it off, click on the on-screen keyboard. The blue color should disappear.
Read More: Excel Not Scrolling with Arrow Keys (4 Suitable Solutions)
4. Disabling Animation on Windows
In case the above methods do not work on your PC, then you must follow this method. In this method, we can also solve the problem effectively by disabling animation on windows PC. To do this you have to follow the following process.
- To start, you have to type Advanced System Settings in the Windows search.
- Then, you have to select the View advanced system settings. When the System Properties window appears, select the Advanced and click on Settings in the Performance section, as shown below image.
- When the Performance Options window appears, you have to uncheck Animate controls and elements inside windows.
- Next, click on OK.
Read More: [Fixed!] Excel Arrows Scrolling Not Moving Cells (6 Possible Solutions)
- How to Stop Excel from Scrolling to Infinity (7 Effective Methods)
- [Solved!] Vertical Scroll Not Working in Excel (9 Quick Solutions)
- How to Repeat Rows in Excel When Scrolling (6 Suitable Ways)
- Horizontal Scroll Not Working in Excel (6 Possible Solutions)
5. Checking ‘Disable Hardware Graphics Acceleration’ Option
Here, we will discuss another effective method to solve the problem by disabling Microsoft Excel animation. Excel overload is usually caused by animations, which require additional processing power. You have to follow the following process to disable Excel animation.
- Firstly, go to File >Options.
- When the Excel Options window appears, select the Advanced Then, check the Disable hardware graphics acceleration. Click on OK.
6. Starting Excel in Safe mode
To solve this problem, one of the options is to run MS Excel in harmless mode, which allows it to run with restricted features and without adding any Excel add-ins. You have to follow the following process to start Excel in a safe mood.
- First of all, press and hold down the Ctrl key when starting Excel.
- In addition, press ‘Windows +R’, type excel.exe/safe, and press Enter.
7. Updating Display Driver
We can also solve the problem by updating the display driver. To do this, we have to follow the following process.
- First of all, press the ‘Win+X’. Then, select the Display Manager.
- Then, the Device Manager window will open.
- Next, you have to expand Display adapters.
- Then, right-click and select Update driver.
8. Repairing Microsoft Office
We can also solve the problem by repairing Microsoft 365. To do this you have to follow the following process.
- Firstly, press ‘Windows+R’. Then, type appwiz.cpl. Next, press Enter. Or you can use a direct way to open Programs and Features in the Control panel.
- Right-click on Microsoft 365 and select Change.
Or you can follow the following steps to repair the Microsoft office.
- To repair, go to the Settings from the windows icon at the bottom-left of your screen.
- Then select Apps.
- After that, click on the Apps & Features from the left of the window.
- Then select your Microsoft Office app and click on Modify under it.
- Now click on Yes if a user account control box appears.
- Next, select Quick Repair or Online Repair depending on the one you prefer, and click on Repair.
That’s the end of today’s session. I strongly believe that from now, you may stop Excel jumping from cells when scrolling. If you have any queries or recommendations, please share them in the comments section below.
Don’t forget to check our website ExcelDemy.com for various Excel-related problems and solutions. Keep learning new methods and keep growing!