Insert header and footer for MS Excel

• Click the View tab. 
• In the Workbook Views group,  click the Page Layout icon. 
• Click in the area marked Click to be, left, center or right aligned.  In our example as shown above,  it's center aligns. 
• Type the desired text in the appropriate box. 
• You also can use the Header & Footer Tools Design Tab,  Header & Footer Elements group to insert the can use appropriate text. If you wish to go to the footer,  click on Go to Footer icon in the Navigation group. 
• Click the Home tab to apply formatting to the text (font,  bold, underline, or color).