This will probably require printing each sheet twice: once to print the data,
a second time to print the header and footer.

i.e. on a separate sheet, set up to print portrait view, do the header and
footer. You may have to add some dummy data to the sheet, to get it to print
at all. Or set up the header and footer in Word and print the sheets there.


On Wed, 26 Jan 2005 07:27:04 -0800, "Michelle"
wrote:

Does anyone know of a way to add a header to the right and left margins of an
excel or word document?

I have a document in Excel that is in Landscape view. We need to add a
header and footer....but......the header and footer need to be in the left
and right margin with the text running vertical. The info in the table needs
to stay horizontal.