HOW DO I REVERT SCROLL BOX TO CURRENT VISIBLE WINDOW?

Using Excel 2003, the vertical scroll bar can become very small if there is a
lot of rows used or data has been deleted. Excel seems to remember the last
cell even though cells are deleted. How do I reset the resolution of the
scroll bar?

The size of that scrollbar is directly related to number of "used rows" in
the worksheet.

To adjust the size of the scrollbar you must change the number of "used
rows" in the worksheet.
Here's how:
http://www.contextures.com/xlfaqApp.html#Unused

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"bak" wrote:

> Using Excel 2003, the vertical scroll bar can become very small if there is a
> lot of rows used or data has been deleted. Excel seems to remember the last
> cell even though cells are deleted. How do I reset the resolution of the
> scroll bar?