Guido said:
My file was 90Kb before I formated some cells and when I saved it, the size jumped to 180kb. Double!
What I think happened is instead of formatting only 5 cells, by mistake I
formatted 5000 cells. But they're still all empty, so does it matter?
Is there any way I can reduce the size back to 90Kb or so, because I copy
this file on my pocket PC and can't afford to waste any memory.
Yes, formatting cells does affect file size whether they are empty or not.
In general, formatting whole rows or columns is preferable to formatting
individual cells. Formatting the whole worksheet is even more efficient. So
the best thing is to format the whole worksheet to the most common
formatting, and then format whole rows and/or columns as necessary, and do
as little formatting of individual cells as possible.
What makes a huge difference to file size is where the 'last used cell' is.
This is the cell at the intersection of the last column with any cell
content or formatting and the last row with any cell content or formatting.
You can get to it using CTRL+END. If this is a long way past the part of the
worksheet you are really using, then delete all rows below your really used
part at least as far down as the last used cell. (You need to delete them,
using Delete on the Edit menu, not just clear them which is what the Delete
key does!) Repeat for columns to the right of your really used area. Save
the workbook and try CTRL+END again - the last used cell will now be where
you expect and the file size much smaller.
