What produces empty rows at the bottom of a spreadsheet?

[Guest]

Why are some spreadsheets bloated, so that 56 lines and 4 columns of data
occupy 1800k rather than the 21 k actually needed to hold the data.
How and why does this happen? It clogs mailboxes and degrades machine
performance, and is not desirable behavior.
Can a user adjust some settings so it doesn't happen?
How can a user tell from within a spreadsheet that it is going to save
bloated (without saving it and looking at the filesize in Windows Explorer)?
Is this issue addressed in Excel Help, and under what heading?

 

[Guest]

You can tell by moving the scroll bars down to the bottom and right, and
seeing how far they go, that's where it thinks the sheets ends.
I don't have this problem often, but when I do, highlighting the empty rows
and columns and deleteing and saving usually fixes it.

 

[Gord Dibben]

Scott

See Debra Dalgleish's site for resetting the used range on a sheet and an
explanation of how the size gets bloated.

http://www.contextures.on.ca/xlfaqApp.html#Unused

If the file has been saved at least once you can go to File>Properties to see
the size.

I don't believe Help has any detail on this "used range" specifically.


Gord Dibben MS Excel MVP