sheet size - scroll bars

  • Thread starter Thread starter jim
  • Start date Start date
J

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
 
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
 
Back
Top