To fix the scrolling problem, the information here will help you reset
the used range:

http://www.contextures.com/xlfaqApp.html#Unused

CarolineHedges wrote:
Currently on some of my spreadsheets, the bar at the side of excel is
really small, ie so if you pull it all the way down to the bottom it
goes to page 1000 and something stupid.

How do I make the bar smaller, so that the view is that of just the
data in the sheet, or one page view.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html