| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting the vertical scroll bar | Excel Discussion (Misc queries) | |||
| vertical excel scroll bar | Excel Discussion (Misc queries) | |||
| Vertical Scroll Bar | Excel Worksheet Functions | |||
| vertical scroll bar goes too far? | Excel Discussion (Misc queries) | |||
| In Excel 2000, how do I add a vertical scroll bar to a split scre. | Excel Discussion (Misc queries) | |||
Hybrid Mode
