Select by SHIFT + End + RightArrow and delete all columns right of your used
range.

Select and delete all rows below your used range.

Save the workbook.

In some versions you have to save/close and re-open to effect a change in
size.


Gord Dibben MS Excel MVP

On Sun, 6 Sep 2009 10:25:01 -0700, CAPTGNVR
wrote:

Dear All

I have only one page text data in an excel sheet but the file size is about
1mb.

Pls tell me what could be the reason and how to make the file smaller.

brgds/captgnvr