workbook header

[Republic1984]

I use excel to generate a report with multiple worksheets. What I need
to do is have all the worksheet have the same header without having to
"setup" each worksheet. Is there anyway of "seting" this up for the
first worksheet and using it for the other worksheets?

thanks in advance.

 

[Frank Kabel]

Hi
just select all the desired worksheets (e.g. hold down the SHIFT key
while selecting them). Afterwards change your heaeder/footer