Excel 2003 vertical scroll bar
 

Is there a way to reset the scroll bar on a worksheet?
For example, I originally had 5,000 rows of data in my worksheet. Now I
only have 200, but my scroll bar is still set to scroll 5,000 rows. How can
I reset the scroll bar to scroll to 200 rows?

Excel 2003 vertical scroll bar
 

hi
see this site to reset the used range.
http://www.contextures.com/xlfaqApp.html#Unused

regards
FSt1

"Josh" wrote:

Is there a way to reset the scroll bar on a worksheet?
For example, I originally had 5,000 rows of data in my worksheet. Now I
only have 200, but my scroll bar is still set to scroll 5,000 rows. How can
I reset the scroll bar to scroll to 200 rows?

Excel 2003 vertical scroll bar
 

Select all the rows beneath your current data.
Delete entire rows (Right click, delete)
Save workbook.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Josh" wrote:

Is there a way to reset the scroll bar on a worksheet?
For example, I originally had 5,000 rows of data in my worksheet. Now I
only have 200, but my scroll bar is still set to scroll 5,000 rows. How can
I reset the scroll bar to scroll to 200 rows?

Excel 2003 vertical scroll bar
 

I tried this out, but it still does not work for me. Any other thoughts or
workarounds?

"FSt1" wrote:

hi
see this site to reset the used range.
http://www.contextures.com/xlfaqApp.html#Unused

regards
FSt1

"Josh" wrote:

Is there a way to reset the scroll bar on a worksheet?
For example, I originally had 5,000 rows of data in my worksheet. Now I
only have 200, but my scroll bar is still set to scroll 5,000 rows. How can
I reset the scroll bar to scroll to 200 rows?

Excel 2003 vertical scroll bar
 

Did you save the workbook after deleting unused rows and columns?

Also......delete...........do not just "clear contents".


Gord Dibben MS Excel MVP

On Mon, 23 Mar 2009 10:42:01 -0700, Josh
wrote:

I tried this out, but it still does not work for me. Any other thoughts or
workarounds?

"FSt1" wrote:

hi
see this site to reset the used range.
http://www.contextures.com/xlfaqApp.html#Unused

regards
FSt1

"Josh" wrote:

Is there a way to reset the scroll bar on a worksheet?
For example, I originally had 5,000 rows of data in my worksheet. Now I
only have 200, but my scroll bar is still set to scroll 5,000 rows. How can
I reset the scroll bar to scroll to 200 rows?