Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing landscape and portrait
Hi,
I would like my first page on the worksheet to print landscape and the remaining pages then to print portrait...... Also i like it when i return from print preview that i can see the dotted outlines. If this could show the first page landscape and the rest portrait that would be even better but thinking it may be a lil hard. Are any of these possible?? -- Jonno |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing landscape and portrait
Record a macro when you:
Change to landscape mode print the first page of the worksheet change to portrait print pages 2 to xxx of the worksheet Hide those dotted lines (and stop the macro) I don't think you'll see the dotted lines the way you want. I'd turn them off if I were you. And I'd make sure that there was a manual page break for that first page. Tools|options|view in xl2003 menus is where you'd find the page breaks (dotted lines) option. Jonno wrote: Hi, I would like my first page on the worksheet to print landscape and the remaining pages then to print portrait...... Also i like it when i return from print preview that i can see the dotted outlines. If this could show the first page landscape and the rest portrait that would be even better but thinking it may be a lil hard. Are any of these possible?? -- Jonno -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing landscape and portrait
Jonno,
Another thing you can do is put your data on 2 separate sheets & group them before print. sheet1 - landscape & sheet2 - portrait. Than hold the control key & click on sheet1 & sheet2 (grouping). Print preview will show both sheets in their separate print formats. If you have page of pages set up, you will get page 1 of xx pages for sheet1 & page 2 of xx pages for sheet2. -- Kevin "Jonno" wrote: Hi, I would like my first page on the worksheet to print landscape and the remaining pages then to print portrait...... Also i like it when i return from print preview that i can see the dotted outlines. If this could show the first page landscape and the rest portrait that would be even better but thinking it may be a lil hard. Are any of these possible?? -- Jonno |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing landscape and portrait
Thanks this is very helpfull and works great!!!!!
-- Jonno "Dave Peterson" wrote: Record a macro when you: Change to landscape mode print the first page of the worksheet change to portrait print pages 2 to xxx of the worksheet Hide those dotted lines (and stop the macro) I don't think you'll see the dotted lines the way you want. I'd turn them off if I were you. And I'd make sure that there was a manual page break for that first page. Tools|options|view in xl2003 menus is where you'd find the page breaks (dotted lines) option. Jonno wrote: Hi, I would like my first page on the worksheet to print landscape and the remaining pages then to print portrait...... Also i like it when i return from print preview that i can see the dotted outlines. If this could show the first page landscape and the rest portrait that would be even better but thinking it may be a lil hard. Are any of these possible?? -- Jonno -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
From portrait to landscape | Excel Worksheet Functions | |||
Landscape Portrait | Excel Discussion (Misc queries) | |||
Printing in Portrait & Landscape | Excel Discussion (Misc queries) | |||
Printing report that is portrait and landscape | Excel Discussion (Misc queries) | |||
Landscape and Portrait | Setting up and Configuration of Excel |