Vertical Scroll Bar

[Nick]

Hi

I was hoping someone could help me with this...

sometimes when i have a lot of data running down my
spreadsheet the vertical scroll bar block becomes very
small to accomodate the amount of data i have. but then
when i get rid of a lot of the data the length of the
vertical scroll bar block stays very small despite me only
having say 50 rows of data.

what i would like to know is whether there is a way to
make the vertical scroll bar block come back to bigger, so
it's easier to grab than when it is very tiny???

Thanks
Nick

 

[Gord Dibben]

Nick

Select the first blank row below your data, say 51.

SHIFT + END + Downarrow to select to absolute bottom.

Edit>Delete>Entire Rows.

Do same for columns to the right of the data.

Now Save and Close the file. Reopen and you're reset.

For maore on this and some VBA code for setting last cell see Debra
Dalgleish's site.

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

Gord Dibben Excel MVP