Scrolling in Excel worksheet

[Louise]

Hi all

Can you help me?? I have several Excel workbooks [office
97], which have all created the same way, however, when I
open some of them and scroll down by clicking onto
the 'little block' inside the scroll bar, it takes you
down the worksheet by a few hundred rows, rather than
just a few.

It doesn't happen all the time, just every so often, but
it's getting annoying!!

Can anybody help??

Thank you.

Louise

 

[Voutsy]

This may not be too much help but, i know that the scroll bar jump
hundreds of cells at a time if you keep the 'shift' key pressed whil
clicking the scroll bar/block.

N.B
You could avoid this by the PAGE UP / PAGE DOWN keys to scroll instea
of that fiddly little bar thing

 

[Gord Dibben]

Louise

Where does Excel take you on a sheet when you hit CRTL + END?

If far below and/or to the right of your actual data range, you can reset the
used range.

See Debra Dalgeish's site for info and instructions.

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

Gord Dibben Excel MVP