![]() |
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? |
HOW DO I REVERT SCROLL BOX TO CURRENT VISIBLE WINDOW?
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? |
All times are GMT +1. The time now is 08:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com