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?
|