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 box
Type the header text
Use the Header & Footer tab to add elements like page number, date, time, file name, or sheet name
Click outside the header area to finish
Save the workbook