If you want to add a header or footer to all sheets, select every sheet by right-clicking one of the sheet tabs at the bottom of the Excel screen and clicking "Select All Sheets" in the pop-up menu.

You can insert or add Header and Footer in Excel spreadsheet using this tutorial. Insert page number, current date and time, etc.

Fortunately, Excel 2007 enables you to select all pages and copy formatting to all of them. This method allows you save precious time and ensure formatting is consistent across all sheets.

The July Technology Q&A column told how to automatically include an Excel header or footer that carries the workbook’s path and filename (such as C: clientfirst quarter results ). We noted that ...