I just noticed that on a particular active WS, the "elevator" in the vertical
scrolling "shaft" was very small. The amount of data on this warticular WS
had recently been winnowed down from some 7.000 rows to about 800. Grabbing
hold of the "elevator", and clicking into the area just above it are both
quite tricky when it's this small, so I wanted to adjust it to a size
appropriate to the number of active rows.

In the end I copied all the active rows to a new WS, deleted the old WS, and
renamed the new WS to the old one's name.

Is there an easier way to do this?
--
Dave
Temping with Staffmark
in Rock Hill, SC