| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create multiple scroll bars within one Excel sheet? | Excel Worksheet Functions | |||
| How increase # visible entries in dropdown list box so no scroll? | New Users to Excel | |||
| Command Button Always Visible in window | Excel Discussion (Misc queries) | |||
| tried using SUBTOTAL function (XL XP) and it doesn't seem to work | New Users to Excel | |||
| make hidden window or workbook visible without specify the name | Excel Worksheet Functions | |||
Linear Mode
