![]() 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |