LARGE File Size

  • Thread starter Thread starter John
  • Start date Start date
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
 
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?
 
Sounds like the picture may be adding some bulk as well

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