Perhaps something like this will help:
http://vbaexpress.com/kb/getarticle.php?kb_id=39

****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"the_melstar" wrote in message
...
Is it possible in the normal view of excel, to show only the cells that
are
in the print region and not unused cells? I particuarly want to remove the
excess rows.

thank you