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.
0 kommentar(er)
