LARGE File Size

J

John

Hi,

I have been given a file that 7.7 meg.

The content is approximately 30 cells x 30 cells. There is some border
formatting but the majority of the cells are empty as it is a timesheet
template.

There is three lines and a small picture in the file.

If I copy all cells over to a new work by pasting values and then pasting
formats & copying over the lines and image, the new file is 66.5K !!!

Any ideas why the same content can have such varying file sizes ???

Thanks
John
 
R

Ron de Bruin

Hi John

Excel can think that the usedrange is bigger then it is.

You can see how big your usedrange is on every sheet with CTRL-END
If the row/column is not the last row/column with data then:

1 Select the first row below your last row with data
2 CTRL-SHIFT-DOWN ARROW
3 Right click on the selection and choose delete

And then for the columns

1 Select the first column next to your last column with data
2 CTRL-SHIFT-RIGHT ARROW
3 Right click on the selection and choose delete

Save the file an close it
See how big the file is now?
 
T

Tom Ogilvy

Sounds like the picture may be adding some bulk as well

since you say you didn't copy the picture.
 
Top