excel 2000

  • Thread starter Thread starter Anon
  • Start date Start date
A

Anon

Handoko said:
Hi ladies and gentleman, i want to ask something about my
excel file which suddenly the capacity become big, from
500 kb became 25 mb, is there any tool to reduce this
excel file become like usual. i already copy and paste it
to new excel workbook. but the file still 25 mb. how come
my file became like this.

plz help me ???

thank you very much

Have a nice day
Click to expand...

Unless you have added lots of charts, graphics or similar, probably there is
something (even a space character or just formatting) in a cell on one (or
more) sheets way beyond the end of the area you are really using. In each
sheet, use CTRL+END to see where Excel thinks the last used cell is. If this
is beyond where you think it should be, delete all rows below your real used
are (at least as far as the place CTRL+END found), using delete on the edit
menu, not the delete key on the keyboard (as that key clears cell contents
rather than deleting the cells). Then do the same for columns to the right
of your real used area. Save the file. (In some versions of Excel you also
need to close Excel and restart it.) CTRL+END should now take you to a
sensible place, and your file should be much smaller.
 
Hi ladies and gentleman, i want to ask something about my
excel file which suddenly the capacity become big, from
500 kb became 25 mb, is there any tool to reduce this
excel file become like usual. i already copy and paste it
to new excel workbook. but the file still 25 mb. how come
my file became like this.

plz help me ???

thank you very much

Have a nice day
 
Back
Top