How to Copy a Page Format to All Pages of a Workbook in Excel 2007. ... It's fairly common to put an Excel header on all pages of all worksheets in your document.

Open an Excel Worksheet and click "Insert." Click the "Text" button followed by "Header & Footer." Excel switches to layout view and displays three empty header columns at the top of the worksheet.

Your Excel spreadsheet may look great onscreen, but when you go to print it, headers and footers may be a problem. Mary Ann Richardson explains how to increase margins and include all your data ...