I have a workbook which has many landscape and portrait pages.I need to print
the Footer and Header in the left and right margins (not Top and Bottom when
looking at the page in landscape), so that when filed away they can follow my
portrait header and Footer.

I could not find anything so I ended up drawing lines in excel of the page
lenghts and width with adjustments to all the margins. Made these lines fixed
lenghts.

Column A rotated text 90 degress with a manual footer and the column T with
the Header. The problem is that when I print preview the drawing lines are
too short in the print preview and the when printed a good 1-3 cm short to
actual lenght. Any body got any suggestions as I have tried many difference
lenghts but can not get a logicall answer nor a good print out.

I have therefore con concluded that if you draw a line in excel of 17cm and
it prints out in about 15cm. Need to get the right lines so that I can get me
Header and footer right in the left and right margin.

Page setup is set to scalling of 100%, Margins tab has no ticks in Center on
page Hortizontally or Vertically

Many thanks
John