Open Header & Footer. (Insert > Header & Footer)
Excel changes to Page Layout view, and your cursor is active in the Header area. You can type content into this area. Or you can use the buttons on the Design tab to insert page numbers, dates, times, and so on.
When you're done editing the header, click any cell. Then if you want, you can change back to Normal view on the View tab.