D
Doc H
Senario
I open a spreadsheet with 50 rows of data and can scroll down to the bottom
of the 50 rows by dragging the slider of the scroll bar down to the bottom
of its bar.
Now I try to select a 1 column x 50 row section by dragging but overshoot
and mark 4000 rows (say!)
Now, even when I correct my mistake, my scroll bar range is 4000 rows and I
can no longer get to the bottomn of my 50 rows easily by using the slider.
How do I tell excel that the 'bottom' row is 50?
Howard
I open a spreadsheet with 50 rows of data and can scroll down to the bottom
of the 50 rows by dragging the slider of the scroll bar down to the bottom
of its bar.
Now I try to select a 1 column x 50 row section by dragging but overshoot
and mark 4000 rows (say!)
Now, even when I correct my mistake, my scroll bar range is 4000 rows and I
can no longer get to the bottomn of my 50 rows easily by using the slider.
How do I tell excel that the 'bottom' row is 50?
Howard