setting the area to show up in preview

[Paul]

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.

 

[Pete_UK]

You can adjust the area to print in the Page Setup option | Sheet tab.
I'm not sure how you get to that in XL 2007.

Hope this helps, though.

Pete

 

[Bob I]

Select desired area, Page Layout tab, Print area.

 

[Paul]

Thanks it worked! Still getting used to all the tabs with Office 2007.