Excel 2007. I'm using a workbook to print a dozen worksheets to go into a report. Is there some way I can enter the report title automatically in the headers of all worksheets? Now, I open each worksheet and type (and format) the title manually.