If you are frustrated by your scrollbars racing way passed your last row, or they are difficult to control, it is likely Excel thinks it has more data than it actually does and you need to reset it's UsedRange. All versions of Excel have an 'issue' with resetting the area it believes it is using on any sheet (UsedRange). This is brought about by say, entering data in columns to the right of the actual data or rows below it. To test where Excel believes it's furthest row or column...