Print in portrait and landscape

[mshah]

I have a worksheet that has 3 pages. I want to be able to print page #s 1 & 2 in portrait and page # 3 in landscape.

Is there any way I can achieve this without having to put the information in two different sheets with different page settings?

[Rick_Stanich]

Using "Print Preview" (Ctrl F2), then select "Page Setup".
Set the printing format you want for that sheet.

You will have to exit "Print Previw" and repeat the steps for each sheet.

Save your workbook and the sheets will retain your settings.

[mshah]

Hi Rick,

Thanks for replying back so quick!

All my three pages are within the same sheet, so I am not sure how I can achieve this using Print Preview.

[Rick_Stanich]

If the number of rows will remain the same you could do something like this:

Please Login or Register  to view this content.