Select desired area, Page Layout tab, Print area.

Paul wrote:

I am using excel 2007 and have a small spread sheet with text entries and
about 10 columns by 10 rows. For some reason when I go to print preview it
only shows the first three rows. Is there a way to print the whole thing to
a single letter sized page in landscape mode, also the print preview should
then show all the rows.
Thanks.