Hi,

Here are two options:

1. Every printable page on One Sheet:
Menu: File/Page Setup.../ select tab Sheet
Here you can select 'Rows to Repeat at top'

2. Every printable page in the whole Workbook (file):
a) Dynamic header (with formulas)
Mark you header area and Copy.
Press Shift. Menu: Edit/Past Picture Link. This is an Dynamic picture.
Copy it and Place it on every new Sheet and do the 1. 'Rows to Repeat at top'

b) Static header (without formulas)
.... in think you already received a good solution...

I think want solution No 1.

Ola