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

Get FREE Advanced Excel Exercises with Solutions!

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.


How to Stop Excel from Jumping Cells When Scrolling: 8 Easy Methods

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.

📌 Steps:

  • First of all, go to Control Panel. Then, select Choose mouse settings.

Utilizing On-Screen Keyboard

  • When the Mouse Properties window appears, then select Wheel. Then, enter 1 in The following number of lines at a time section.

How to Stop Excel from Jumping Cells when Scrolling

This method will help you to stop Excel from jumping cells while scrolling.


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.


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.

📌 Steps:

  • 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.

Utilizing On-Screen Keyboard

  • 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.

How to Stop Excel from Jumping Cells when Scrolling


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.

 📌 Steps:

  • 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.

Disable Animation on Windows

  • When the Performance Options window appears, you have to uncheck Animate controls and elements inside windows.
  • Next, click on OK.

How to Stop Excel from Jumping Cells when Scrolling


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.

📌 Steps:

  • Firstly, go to File >Options.

Disable Microsoft Excel Animation

  • When the Excel Options window appears, select the Advanced option. Then, check the Disable hardware graphics acceleration. Click on OK.

How to Stop Excel from Jumping Cells when Scrolling


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.

📌 Steps:

  • 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.

Start Excel in Safe mode


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.

📌 Steps:

  • 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.

Updating Display 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.

📌 Steps:

  • 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.

Repair Microsoft Office

  • 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.

How to Stop Excel from Jumping Cells when Scrolling

  • 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.

How to Stop Excel from Jumping Cells when Scrolling

Read More: Horizontal Scroll Not Working in Excel


<< Go Back to Learn Excel | Navigation | Scrolling


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


Conclusion

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. Keep learning new methods and keep growing!


Related Articles


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

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Saquib Ahmad Shuvo
Saquib Ahmad Shuvo

Saquib Ahmad Bhuiyan, holding a BSc degree in Naval Architecture & Marine Engineering from Bangladesh University of Engineering and Technology, skillfully integrates engineering expertise with a passion for Excel. He provides solutions to complex issues as an Excel & VBA Content Developer for ExcelDemy Forum. He demonstrates an enthusiastic mindset and adeptness in managing critical situations with finesse, showcasing his commitment to excellence. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel, Rhinoceros,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo