Open the Excel workbook
Click the worksheet where you want the header
Go to the Insert tab
Click Header & Footer
Click in the left, center, or right header section
Type the header text
Click outside the header area to save it
Use Page Layout view if needed to see the header
To add a different header on each sheet, repeat the steps on each worksheet