View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
dlw dlw is offline
external usenet poster
 
Posts: 510
Default 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?