Whereas this is not an ideal solution, it does provide you with the desired result. Method 1: Hiding Rows or Columns (not the best way) Here is how you can get rid of Scroll Trouble in Excel in three different ways. But our problem is that cell A200 has no value for us and we would like for the scroll bar to only go from the first row to the last row with data (in this case row 100). This is a feature! Excel thinks that since you have taken the time to format cell A200 that cell must be important to you and you are just waiting to input some data into it and therefore it still gives you the ability to move swiftly to it by using the scroll bar. One might expect for the scroll bar to go back to row 100 as the bottom line, but it does not.

All as it should be so far.īut then you delete this entry and Save the file. And it’s not a shock that at this point, the vertical Scroll Bar goes all the way to row 200. Now someone decides to put something non trivial (something that includes some formatting like a date or currency) into cell A200. At this point the vertical Scroll Bar goes from row 1 to row 100. Just for reference, this is what we are talking about. If you like learning from Video more that you do from Blog Posts, here is a link to a video on my YouTube channel teaching you basically the same thing: This post will show you how to make Excel “reset” the Scroll Bar in three different ways. And even if they remove any trace of their wayward journey, a scroll bar remembers it. Sometimes in Excel, people insert data in places where they weren’t supposed to.

Excel how many rows are there data in