Scroll Bar Range
 

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.

The information here will help you reset the used range:

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

"Tanker Mike" wrote:

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.