Mixed page orientation on same worksheet

[shj92922]

hello
i had a work sheet which contain monthly report for page 1 (Portrait page) and my second page is full year analysis (landscape page)
so i want to save them as pdf file
what i do is save as pdf file
but the problem is for page 2 it save both sheet on portrait view while i want first page to be portrait and second is landscape
is there is a way to do it on same sheet
thanks

[6StringJazzer]

The best solution is to put them on two sheets. You can still save them to a single PDF file. Another solution would be to use VBA to manage the printing, but that would be a lot more complicated than just putting the data on two sheets.

[shj92922]

thanks for reply rhats i know put them on 2 sheet

thanks for reply