If you hit ctrl-End, you're taken to the lastused cell of the worksheet.

Does that match what you think it should be?

If no, visit Debra Dalgleish's site for some techniques for resetting that
lastusedcell.
http://www.contextures.com/xlfaqApp.html#Unused

Any chance you have pictures/shapes/objects that are bloating the size?

And (one I just learned about), do you have any range names that bloat the size?

Eric wrote:

My Excel file sizes are huge. I have one workbook that is just one worksheet
and it is 4 mb. One thing I did was run a macro and copy the results onto
this separate workbook, but it shouldn't make the file 4mb!!

--

Dave Peterson