| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort with empty rows between none empty rows? | Excel Worksheet Functions | |||
| unwanted empty rows at worksheet bottom | Excel Discussion (Misc queries) | |||
| Pivot Tables: How do I show ALL field rows, including empty rows?? | Excel Worksheet Functions | |||
| How do I delete blank rows at the bottom of a spreadsheet to get . | Excel Discussion (Misc queries) | |||
| empty rows at bottom of worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
