What produces empty rows at the bottom of a spreadsheet?
 

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?

What produces empty rows at the bottom of a spreadsheet?
 

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.

"scottdac" wrote:

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?

What produces empty rows at the bottom of a spreadsheet?
 

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 FileProperties to see
the size.

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


Gord Dibben MS Excel MVP

On Thu, 3 May 2007 09:53:01 -0700, scottdac
wrote:

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?