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.

Excel switches to layout view and displays three empty header columns at the top of the worksheet. Click inside the center column and type the text you'd like to appear as the worksheet's header.

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

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 ...