How to shorten a spreadsheet
Posted: 03-01-2006, 07:31 PM
I have a spreadsheet with a list, using List Manager. My list ends on
row 1143. However, if I pull the scroll bar down to the bottom of the
spreadsheet, it ends at row 9253. I can click the down arrow and
continue to display more rows.
This is a pain because it makes the scroll bar VERY sensitive to the
slightest movement when I'm trying to navigate my list.
My other spreadsheet files, also containing lists, do not do this.
There are just a few (maybe 50 or less) extra rows below the list, so
the scroll bar is much more useful.
I have looked over the problematic spreadsheet for an errant bit of info
entered in one of the very last cells (row ~9253) but can't find
anything to cause this. I also don't see any preferences related to how
many extra rows to display.
Anyone know how to fix this?
I'm using Excel 11.2 (Office 2004) under OS 10.3.9.