how to set "end" of worksheet/limit scrollbar range

P

Peter Atherton

Kelly

You doo not have to set the end - Excel does this
automatically.

The vertical scoll bar resizes itself depening on the
data. open a blank sheet and the scroll bar fills most of
the page and you can only use it to move down one extra
row.

Fill in 100 rows and the scroll bar shrinks to a small
button and dragging it down will display the last cell
with data

Regards
Peter
 
Top