Excel

Hi All

I need to know if it is possible to have two different page set ups in the same document. For eg Sheet 1 has a document that is six pages long when printed I need pages 4 - 6 printed in portfolio and pages 1 - 3 printed in landscape. Is there a way to do this if so how?

Thanks
Jodie

You can surely do it manually. However, have you tried to do this by yourself?

Like selecting first 1-3 pages then selecting 'Page Setup' and choosing landscape, etc.

Then save the document, then re-open it and check to see if the settings have remained, if so, they will be printed as the same too.

As far as I'm aware, you cannot set multiple print areas on a single worksheet. This means that you'll be stuck with the same layout throughout the entire sheet.

What I would recommend is creating a print macro that will automate the manual process that was described above. This would allow you to change the page setup before printing each range of pages.