Home |
Search |
Today's Posts |
#1
|
|||
|
|||
vertical scroll bar goes too far?
I have a workbook that has a number of worksheets in it. Most of the sheets,
with 200 rows, allow me to use the vertical scroll bar to scroll to the last row and stop. However, I have one sheet that allows me to scroll to the bottom of the worksheet (row 65K). What would cause this... I have cleared all the cells and rows under my last populated cell, no print area, no cell formatting. Thanks. |
#2
|
|||
|
|||
The information here will help you reset the used range on that sheet:
http://www.contextures.com/xlfaqApp.html#Unused ScottSabo wrote: I have a workbook that has a number of worksheets in it. Most of the sheets, with 200 rows, allow me to use the vertical scroll bar to scroll to the last row and stop. However, I have one sheet that allows me to scroll to the bottom of the worksheet (row 65K). What would cause this... I have cleared all the cells and rows under my last populated cell, no print area, no cell formatting. Thanks. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Thank you. Seems simple enough.
"Debra Dalgleish" wrote: The information here will help you reset the used range on that sheet: http://www.contextures.com/xlfaqApp.html#Unused ScottSabo wrote: I have a workbook that has a number of worksheets in it. Most of the sheets, with 200 rows, allow me to use the vertical scroll bar to scroll to the last row and stop. However, I have one sheet that allows me to scroll to the bottom of the worksheet (row 65K). What would cause this... I have cleared all the cells and rows under my last populated cell, no print area, no cell formatting. Thanks. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scroll horizontaly with mouse, create same system used to scroll . | New Users to Excel | |||
How do I limit the vertical scroll? | Setting up and Configuration of Excel | |||
horizontal & vertical scroll bars | Excel Worksheet Functions | |||
In Excel 2000, how do I add a vertical scroll bar to a split scre. | Excel Discussion (Misc queries) | |||
Scroll bars (vertical and horizontal). | Excel Discussion (Misc queries) |