After inserting the column, you may have affected the "dirty area" of
the worksheet. Press Ctrl-End and see where you end up. If it is far
below your data, delete the empty rows/columns and save your file.

Check out http://support.microsoft.com/kb/244435 for more help.

HTH,
JP

On Mar 12, 11:36*am, "Barkley Bees" wrote:
I have an odd situation I was hoping some of you excel experts might be able
to help me with. I was sent a spreadsheet (task schedule list) that was
about 25kb (only 40 rows by 8 columns).
After I did some editing (adding 2 new columns and adding some information
to them) and saved the file, I noticed the file size has ballooned up to
2MB!

I went hunting through the file to see if had accidentally pasted a
something huge from my clipboard but could find nothing. I know it is the
column I added as when I delete the entire column and save the file it goes
back to the original 25kb. But when I delete the rows from this column where
I added data (knowingly!) the file size does not change....it remains 2MB.

I manually scrolled down from row 41 to 65,536 and could see nothing but
white cells. I figure there's some data hidden in there but I can't seem to
figure out how to find it. Can anyone recommend a good way to hunt this
down? Much appreciated.