| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
setting the area to show up in preview
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. -- Paul G Software engineer. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
setting the area to show up in preview
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 On Jan 28, 5:22*pm, 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. -- Paul G Software engineer. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
setting the area to show up in preview
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
setting the area to show up in preview
Thanks it worked! Still getting used to all the tabs with Office 2007.
-- Paul G Software engineer. "Bob I" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting margins in page break preview | Excel Discussion (Misc queries) | |||
| Setting print area | Excel Discussion (Misc queries) | |||
| Page breaks shift after preview/setting print pref | New Users to Excel | |||
| How do you show plot area only-no chart area | Charts and Charting in Excel | |||
| Dashboard Reporting - plot area changes on print preview | Charts and Charting in Excel | |||
Linear Mode
