Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I set a maximum value for the scroll bars in Excel?
When I use the scroll bars to navigate my worksheet, they go way beyond the
last row I've used and the last column that I've used, which is annoying. I have checked to see if there is some random data in any of the additional unused cells and am not able to find any. I have tried unsuccessfully to delete the rows and columns and to delete the cells or cell content. It appears that the solution has to do with the "maximum value" of the scroll bars, but I can't find out how to set that. I'm using Excel 2000. Any thoughts would be great. Thanks! |
#2
|
|||
|
|||
How do I set a maximum value for the scroll bars in Excel?
Debra Dalgleish has some techniques for resetting the usedrange:
http://www.contextures.com/xlfaqApp.html#Unused PipsPerson wrote: When I use the scroll bars to navigate my worksheet, they go way beyond the last row I've used and the last column that I've used, which is annoying. I have checked to see if there is some random data in any of the additional unused cells and am not able to find any. I have tried unsuccessfully to delete the rows and columns and to delete the cells or cell content. It appears that the solution has to do with the "maximum value" of the scroll bars, but I can't find out how to set that. I'm using Excel 2000. Any thoughts would be great. Thanks! -- Dave Peterson |
#3
|
|||
|
|||
How do I set a maximum value for the scroll bars in Excel?
Thank you so much -- it worked beautifully! It is a problem that has been
bugging me for ages and now it is resolved! "Dave Peterson" wrote: Debra Dalgleish has some techniques for resetting the usedrange: http://www.contextures.com/xlfaqApp.html#Unused PipsPerson wrote: When I use the scroll bars to navigate my worksheet, they go way beyond the last row I've used and the last column that I've used, which is annoying. I have checked to see if there is some random data in any of the additional unused cells and am not able to find any. I have tried unsuccessfully to delete the rows and columns and to delete the cells or cell content. It appears that the solution has to do with the "maximum value" of the scroll bars, but I can't find out how to set that. I'm using Excel 2000. Any thoughts would be great. Thanks! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use the mouse wheel to scroll horizontally in excel? | Excel Discussion (Misc queries) | |||
Excel opens saved workbook without tabs or scroll bars showing? | Excel Worksheet Functions | |||
Enough with Scroll Lock in Excel 2003 | Setting up and Configuration of Excel | |||
How do I sort for the maximum values in each year in excel? | Excel Discussion (Misc queries) | |||
horizontal & vertical scroll bars | Excel Worksheet Functions |