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.