sheet size - scroll bars

[jim]

Hi all,

I have a strange question.

I have a sheet that has maybe 100 rows. The scroll bar on the right allows
me to move quickly from top to bottom etc.

I then delete, or move to another sheet say 80 rows.
The scroll bars remain aligned or sized to a sheet with 100 rows.

Is there any way to resize the scroll bars to active data only, or maybe
occupied rows.


jim

 

[Gord Dibben]

Jim

You can reset the "apparent" used range by deleting rows below your "real"
used range the save the workbook. Some versions also require a close and
reopen before you see any change.

Note: this must be done for each worksheet in the workbook.

Debra Dalgleish has more info and posted code to reset the used range of all
worksheets using a macro.

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

Gord Dibben Excel MVP XL2002