[Fixed!] Excel Scrolling Too Many Rows (2 Easy Solutions)

When working with Excel, sometimes we have to work with very large datasets. In this case, scrolling gets too sensitive, as we move too many rows with a little bit of scrolling then. Now, you might need to fix the scrolling so you don’t move too many rows. In this article, I will show you how to fix scrolling too many rows in Excel.

Excel Is Scrolling Too Many Rows: 2 Ways to Fix It

Say, you have a sales record of a company for the months of January and February. If you scroll downward, you move three rows at a time. But you need to move one row at a time per scroll. You can follow any of the ways below to fix the scrolling too many rows in Excel.

Excel Scrolling Too Many Rows Issue

Solution 1: Change the Scroll Settings of Your Windows

The easiest and quickest way to fix the scrolling issue is to change the scroll settings of your windows. Follow the steps below to do this.

📌 Steps:

  • First, click on the Start menu icon of your windows.
  • Afterward, click on the Settings icon from the popped-up windows menu.

Access the Windows Settings of Your PC

  • As a result, the Windows Settings window will appear.
  • Following, click on the Devices option from the window.

Access the Devices Settings Window

  • Afterward, click on the Mouse option from the Devices group.
  • As a result, the Mouse settings window will appear.

Access the Mouse Settings Window

  • Subsequently, choose the Multiple lines at a time option from the Roll the mouse wheel to scroll options.
  • Following, put the Choose how many lines to scroll each time lever at level 1.

Drag the Lever to Fix Excel Scrolling Too Many Rows

Thus, you will get your issue fixed. So, you can scroll only one row at a time now. For example, the scrolling would look like this now.

Fixed Excel Scrolling Too Many Rows Issue

Solution 2: Use the Scroll Bar’s Arrow Buttons

Another way to fix your scrolling issue is to use the scroll bar’s arrow buttons. Follow the steps below to do this.

📌 Steps:

  • At the very beginning, open your Excel file.
  • Now, look in the rightward direction to find the vertical scroll and rightly downward to find the horizontal scroll.

Excel Scroll Bar Arrow Button

  • Now, click on your scroll according to the direction that you want to go.

As a result, you can fix your scrolling issue and thus you can scroll only one row at a time per scroll.

Fixed Excel Scrolling Too Many Rows Issue

How to Stop Excel from Scrolling to Infinity

Now, sometimes, it might happen that Excel is scrolling to infinity automatically when you scroll down or right. Now, to stop Excel from scrolling to infinity, go through the steps below.

📌 Steps:

  • First, go to the Developer tab >> Properties tool.

Access the Properties Tool

  • As a result, the Properties window will appear.
  • Following, go to the option ScrollArea.
  • Subsequently, insert your desired dataset range (A1:D17 here) in the ScrollArea text box.

Declare Scroll Area to Stop Excel from Scrolling to Infinity

Thus, you have limited the scroll area in Excel by declaring the range. So, Excel will not scroll to infinity automatically and thus you will be able to scroll only between your declared range.

Stopped Excel from Scrolling to Infinity

Read More: Smooth Scrolling with Mouse Wheel in Excel 

Download Practice Workbook

You can download our practice workbook from here for free!


So, in this article, I have shown you 2 easy fixes to scrolling too many rows in Excel. You can also download our free workbook to practice. I hope you find this article helpful and informative. If you have any further queries or recommendations, please feel free to comment here.

Have a nice day! Thank you!

Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!
Tanjim Reza
Tanjim Reza

Md. Tanjim Reza Tanim, a BUET graduate in Naval Architecture & Marine Engineering, contributed over one and a half years to the ExcelDemy project. As an Excel & VBA Content Developer, he authored 100+ articles and, as Team Leader, reviewed 150+ articles. Tanim, leading research, ensures top-notch content on MS Excel features, formulas, solutions, tips, and tricks. His expertise spans Microsoft Office Suites, Automating Finance Templates, VBA, Python, and Developing Excel Applications, showcasing a multifaceted commitment to the... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF