how to prevent worksheet scroll bar to be bigger than working are.

[Worksheet AREA]

Would like to limit the size of working area
After adding columns or/and lines ; the area of the sroll bar goes to the max
Please anyone has idea how to prevent this
Tired of copy in paste to new one.

IS there any way of setting the size of worksheet(s)?
Many THANKS
BEn

 

[Gord Dibben]

Excel sometimes over-estimates the "used range" of a worksheet due to data
being entered then deleted.

Debra Dalgleish has good info on methods to reset the used range.

http://www.contextures.on.ca/xlfaqApp.html#Unused


Gord Dibben Excel MVP

On Wed, 16 Mar 2005 05:39:08 -0800, "Worksheet AREA" <Worksheet