Scroll Bar Range

[Tanker Mike]

How do I limit the range of the scroll bar? Sometimes I get worksheets that
appear to cover the entire range of cells rather than the area of the data on
the sheet.

 

[Debra Dalgleish]

The information here will help you reset the used range:

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