headers on muliple sheets

[Guest]

I have a workbood with several spreadsheets, some of the spreadsheets are in portrait and others are in landscape mode. I am trying to put a header on the sheets. My problem is that I want the header to be in the same place on the landscape sheets as in the portrait sheets. I want the header on the landscape pages to appear as if it were in portrait. Is this possible?

 

[Andy B]

Hi

If you go to View / Toolbars / Customise and look in the Tools list, there
is a camera option. Drag this to your toolbar.
You can now select a range and use this button to 'take a picture' of your
range which you can paste into a portrait sheet and rotate as necessary. Ths
picture stays linked to the original data, too.

Andy.

I have a workbood with several spreadsheets, some of the spreadsheets are

in portrait and others are in landscape mode. I am trying to put a header on
the sheets. My problem is that I want the header to be in the same place on
the landscape sheets as in the portrait sheets. I want the header on the
landscape pages to appear as if it were in portrait. Is this possible?