delete extra columns and rows

I have an excel worksheet.

Currently I'm only using 700+ rows and about 15 colums. However I could
scroll down to the 10 millionth row if I wanted. How do I get rid of all
those extra rows? Same problem with the cloumns. I basically want someone to
open up my file and see that there aren't an infinate number of rows yet to
be populated.

I found this macro that was supposed to delete all empty rows. it ran and
they were still there.

Excel ALWAYS has 65536 rows and 256 columns, and you can't change that no
matter what you do.
However, you can hide them.
use F5 (goto). and type 750:65536, press OK, then use Ctrl/9
then use F5, type P:IV, press OK, then use ctrl/0

Now the extraneous ones are hidden from view.

"matt charlton" <[email protected]> wrote in message
news:[email protected]...
> I have an excel worksheet.
>
> Currently I'm only using 700+ rows and about 15 colums. However I could
> scroll down to the 10 millionth row if I wanted. How do I get rid of all
> those extra rows? Same problem with the cloumns. I basically want someone
to
> open up my file and see that there aren't an infinate number of rows yet
to
> be populated.
>
> I found this macro that was supposed to delete all empty rows. it ran and
> they were still there.