Excel Spreadsheet Keeps Adding Rows

[Bigfish]

Version: 2004
Operating System: Mac OS X 10.3 (Panther)

The Excel document that I use is a shared document between a few Macs and a PC, but it seems as though every time anyone adds a row or rows, many blank rows are added to the bottom of the Spreadsheet, so that we end up with thousands of rows, and the document keeps getting bigger and bigger. It's not so much of a problem except that the scroll bar ends up being like a "hair trigger," in that you have to move it only an inch or so and you're at the end of the completed rows. How do we keep it from adding rows?

 

[JE McGimpsey]

Version: 2004
Operating System: Mac OS X 10.3 (Panther)

The Excel document that I use is a shared document between a few Macs and a
PC, but it seems as though every time anyone adds a row or rows, many blank
rows are added to the bottom of the Spreadsheet, so that we end up with
thousands of rows, and the document keeps getting bigger and bigger. It's not
so much of a problem except that the scroll bar ends up being like a "hair
trigger," in that you have to move it only an inch or so and you're at the
end of the completed rows. How do we keep it from adding rows?

You're actually not adding rows - every XL04 spreadsheet contains
exactly 65,536 rows. The interface hides most of them until they're
needed/used (even by formatting).

Try: Delete all the rows from the "bottom" to the row below your last
used row. Put the cursor in an empty cell within your used range, then
delete it (don't undo). Save the file. When you open it, the scroll
range should be reset.