Calibrate vertical scroll bar to display active rows in worksheet: click scroll bar for desired row.
Calibrate vertical scroll bar to display active rows in worksheet. Always have the slider located exactly in the middle of the scroll bar. Instead of using the slider just click on the approximate row number you want above or below the slider. Once scroll bar is clicked slider will locate to selected approximate row and scroll bar will display active rows above the slider and the active rows below the slider. If implemented I personally will save lots of scrolling time in my worksheets that average over 8000 active rows.