Excel 2003 vertical scroll bar

J

Josh

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?
 
L

Luke M

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

Josh

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

Gord Dibben

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

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


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top