Open the Excel workbook
Click the worksheet you want to add a header to
Go to the Insert tab
Click Header & Footer
Click in the left, center, or right header box
Type the header text
Click outside the header area to finish
To add a different header on each page, use the Header & Footer Tools options
To edit an existing header, click the header area and make your changes
To remove a header, delete the text from the header box