To phrase the response in a different way:

If the active spreadsheet is large in a particular direction the scroll box
is small and takes you a long way when you drag it, if the active spreadsheet
is small then the scroll box is large and it only takes you a short distance.

The active spreadsheet is defined to go as far right as the last column with
something in it, and the last row with something in it. So if C1 has your
name and A10 is bold, the active spreadsheet is A1:C10, assuming nothing else
exists in the sheet further out. Note formatting counts and so do comments,
even if you can't see them.

When you drag the vertical scroll box it goes as far as the last active row
and similarly with the horizontal scroll box.

Now here is the real trick: If you want to move ANY distance in any
direction using the scroll box hold down the Shift key as you drag it. You
can go all the way to the bottom or right, outside the bounds of the active
area.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Lithium" wrote:

Sorry. I meant to say I am using Excel 2000.