Change size of scroll bar

[Guest]

After changing the entries on a spreadsheet, the scroll bar is miniscule for
the number of entries. My question is, how can I reset the
scroll bar on the side of the worksheet. As you can
imagine the data is much smaller at the beginning of the
year than at the end and the scroll button is small
(reflecting the old data size) so I have to basically hunt
for the end of the data with the scroll button when I want
to sort/subtotal things.

 

[Vasant Nanavati]

Saving the file will reset the size of the "thumb."

 

[Dave Peterson]

Debra Dalgleish has some techniques for trying to reset it:
http://www.contextures.com/xlfaqApp.html#Unused

 

[Dave Peterson]

I thought that thingy was called the "elevator" (for even the horizontal
scrollbar)! <vbg>

 

[Vasant Nanavati]

Must be a Midwestern thing ... first time this sheltered New Yorker has
heard of this usage <g>.

 

[jbonaventura]

Thanks, Dave...

Debra's article did the trick !!!

JIm