Excel automaticaly ajusts the scroll bar as your file grows in width and hight, but it does not do this automaticaly when it shrinks. Is there a way to reset the scroll bars?
I have a document that we use that varies alot in length from week to week (sometimes 100 lines, sometimes 1000 lines). When the document has 1000 lines it's fine as the buttom of the scroll bar is pretty much close to the end of the file, but when it's only 100 the end of the scroll bar is way to far away from the actual end of file.
I know that you can just recreate a new file and copy paste the content and the scroll bar will adjust, but there must be away to do it directly in a file.
Thanks
Jooquase.
I have a document that we use that varies alot in length from week to week (sometimes 100 lines, sometimes 1000 lines). When the document has 1000 lines it's fine as the buttom of the scroll bar is pretty much close to the end of the file, but when it's only 100 the end of the scroll bar is way to far away from the actual end of file.
I know that you can just recreate a new file and copy paste the content and the scroll bar will adjust, but there must be away to do it directly in a file.
Thanks
Jooquase.