Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Print both Portrait and Landscape - Excel
I have a two page document. The first page should be in landscape Orientation
and the second in Portrait. Is it possible to print the two different orientations from Excel?? Thanks! |
#2
|
|||
|
|||
Go to the View menu, custom views.
Basically a 'view' in excel saves everything about print settings. so you set up how you want a page to print.. Including column widths, headers & footers, margins etc. then go to view menu, custom views. Then set up the second tab to print... when you've saved the settings, save that view as well. to combine views into a report, you have to use the report manager. It's a standard add-in, but not loaded automatically. From the tools menu, click add-ins and Report manager.. this will let you combine multiple views into a report. "Georgie77" wrote: I have a two page document. The first page should be in landscape Orientation and the second in Portrait. Is it possible to print the two different orientations from Excel?? Thanks! |
#3
|
|||
|
|||
I assume you are talking about something in an Excel worksheet. As far as I
know, you can change the page orientation by worksheet, but not within the worksheet. "Georgie77" wrote: I have a two page document. The first page should be in landscape Orientation and the second in Portrait. Is it possible to print the two different orientations from Excel?? Thanks! |
#4
|
|||
|
|||
I don't have Report Manager as an option for my add-ins. Must I load it from
the source disk? "TomHinkle" wrote: Go to the View menu, custom views. Basically a 'view' in excel saves everything about print settings. so you set up how you want a page to print.. Including column widths, headers & footers, margins etc. then go to view menu, custom views. Then set up the second tab to print... when you've saved the settings, save that view as well. to combine views into a report, you have to use the report manager. It's a standard add-in, but not loaded automatically. From the tools menu, click add-ins and Report manager.. this will let you combine multiple views into a report. "Georgie77" wrote: I have a two page document. The first page should be in landscape Orientation and the second in Portrait. Is it possible to print the two different orientations from Excel?? Thanks! |
#5
|
|||
|
|||
Hmmmmm..
Sorry, I just checked mine too and it's not there either.. I know the report manager was there in earlier versions.. I'll look at the knowledge base.. BUT at the very least, you CAN still use the different views... Even that will save some time switching the print settings back and forth... "Barb R." wrote: I don't have Report Manager as an option for my add-ins. Must I load it from the source disk? "TomHinkle" wrote: Go to the View menu, custom views. Basically a 'view' in excel saves everything about print settings. so you set up how you want a page to print.. Including column widths, headers & footers, margins etc. then go to view menu, custom views. Then set up the second tab to print... when you've saved the settings, save that view as well. to combine views into a report, you have to use the report manager. It's a standard add-in, but not loaded automatically. From the tools menu, click add-ins and Report manager.. this will let you combine multiple views into a report. "Georgie77" wrote: I have a two page document. The first page should be in landscape Orientation and the second in Portrait. Is it possible to print the two different orientations from Excel?? Thanks! |
#6
|
|||
|
|||
Thanks Microsoft..
Well, this USED to be out of the box functionality.. Looks like you have to download the report manager add in now... Sorry (but it does work really well) http://support.microsoft.com/default...b;en-us;873209 "Barb R." wrote: I don't have Report Manager as an option for my add-ins. Must I load it from the source disk? "TomHinkle" wrote: Go to the View menu, custom views. Basically a 'view' in excel saves everything about print settings. so you set up how you want a page to print.. Including column widths, headers & footers, margins etc. then go to view menu, custom views. Then set up the second tab to print... when you've saved the settings, save that view as well. to combine views into a report, you have to use the report manager. It's a standard add-in, but not loaded automatically. From the tools menu, click add-ins and Report manager.. this will let you combine multiple views into a report. "Georgie77" wrote: I have a two page document. The first page should be in landscape Orientation and the second in Portrait. Is it possible to print the two different orientations from Excel?? Thanks! |
#7
|
|||
|
|||
I just DL'd it from the knowledge base, but don't know what to do with it.
Suggestions? "TomHinkle" wrote: Hmmmmm.. Sorry, I just checked mine too and it's not there either.. I know the report manager was there in earlier versions.. I'll look at the knowledge base.. BUT at the very least, you CAN still use the different views... Even that will save some time switching the print settings back and forth... "Barb R." wrote: I don't have Report Manager as an option for my add-ins. Must I load it from the source disk? "TomHinkle" wrote: Go to the View menu, custom views. Basically a 'view' in excel saves everything about print settings. so you set up how you want a page to print.. Including column widths, headers & footers, margins etc. then go to view menu, custom views. Then set up the second tab to print... when you've saved the settings, save that view as well. to combine views into a report, you have to use the report manager. It's a standard add-in, but not loaded automatically. From the tools menu, click add-ins and Report manager.. this will let you combine multiple views into a report. "Georgie77" wrote: I have a two page document. The first page should be in landscape Orientation and the second in Portrait. Is it possible to print the two different orientations from Excel?? Thanks! |
#8
|
|||
|
|||
Thank you SO very much... You have solved an office-wide mystery!
-- Thanks! Gerogie77 "TomHinkle" wrote: Thanks Microsoft.. Well, this USED to be out of the box functionality.. Looks like you have to download the report manager add in now... Sorry (but it does work really well) http://support.microsoft.com/default...b;en-us;873209 "Barb R." wrote: I don't have Report Manager as an option for my add-ins. Must I load it from the source disk? "TomHinkle" wrote: Go to the View menu, custom views. Basically a 'view' in excel saves everything about print settings. so you set up how you want a page to print.. Including column widths, headers & footers, margins etc. then go to view menu, custom views. Then set up the second tab to print... when you've saved the settings, save that view as well. to combine views into a report, you have to use the report manager. It's a standard add-in, but not loaded automatically. From the tools menu, click add-ins and Report manager.. this will let you combine multiple views into a report. "Georgie77" wrote: I have a two page document. The first page should be in landscape Orientation and the second in Portrait. Is it possible to print the two different orientations from Excel?? Thanks! |
#9
|
|||
|
|||
We are using Excel 2003, a newer version, and we cannot find this Report
Manager. Any other suggestions? -- Thanks! "TomHinkle" wrote: Thanks Microsoft.. Well, this USED to be out of the box functionality.. Looks like you have to download the report manager add in now... Sorry (but it does work really well) http://support.microsoft.com/default...b;en-us;873209 "Barb R." wrote: I don't have Report Manager as an option for my add-ins. Must I load it from the source disk? "TomHinkle" wrote: Go to the View menu, custom views. Basically a 'view' in excel saves everything about print settings. so you set up how you want a page to print.. Including column widths, headers & footers, margins etc. then go to view menu, custom views. Then set up the second tab to print... when you've saved the settings, save that view as well. to combine views into a report, you have to use the report manager. It's a standard add-in, but not loaded automatically. From the tools menu, click add-ins and Report manager.. this will let you combine multiple views into a report. "Georgie77" wrote: I have a two page document. The first page should be in landscape Orientation and the second in Portrait. Is it possible to print the two different orientations from Excel?? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Landscape worksheet with portrait header/footer | Excel Discussion (Misc queries) | |||
Printing multiple portait and landscape workbooks at the same time | Excel Discussion (Misc queries) | |||
can't get to change from portrait to landscape even after clicked. | Excel Discussion (Misc queries) | |||
Set page to Landscape Still prints as Portrait | Excel Discussion (Misc queries) | |||
ofice 2003 powerpoint does not print in landscape mode | Excel Discussion (Misc queries) |