go to the fifth column and select. hit shift+ctrl+right arrow. right
click and delete.
go to first blank row of data. hit shift+ctrl+down arrow. right click
and delete. save the file and it should be much smaller.

i've had this issue many times with excel where if you just hit delete
on your keyboard, it doesnt really delete the memory used unless you
delete the actual cell and that frees up the memory.


--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=474651