MrExcel.com - Your One Stop for Excel Tips & Solutions

Getting Custom Header to print on multiple worksheets

Posted by Mary on August 05, 2001 4:21 PM

I have a workbook that has different sheets for each month. I have typed a custom header for the 1st month that I would like to appear on all pages for all months - but when I pull up the 2nd and 3rd sheets, etc. the custom header is no longer there and has to be entered from scratch again. Is there a way to customize the header list so that this header will be available for all worksheets?

Posted by Dax on August 05, 2001 4:27 PM

If you select all the sheets you want to apply the header/footer to, then apply the header/footer it will then be shown on the printout for each sheet.

HTH,
Dax

Posted by Mary on August 06, 2001 8:03 PM

Dax, Thanks for your quick reply. I tried your suggestion and it worked great!