Resizing scroll box

[prodrafter]

Someone has opened an Excel file and scrolled all the way to the bottom
of the spreadsheet and now the scroll box is very thin and my data ends
about 1/4 to 1/3 way down. I know there is a way to re-set the
spreadsheet so the scroll box is more useable but can't remember nor
can I find it in the help file. Can anyone out there help me, please?

Thanks in advance

 

[Dave Peterson]

Debra Dalgleish shows techniques to reset that last used cell:
http://contextures.com/xlfaqApp.html#Unused

 

[prodrafter]

Thanks.
That did the trick.