Excel 2016 – How to edit worksheet header/footer

The following steps show how to edit a worksheet header/footer in Microsoft Excel.

  1. With the Excel document open, click on ‘View’ in the ribbon
  2. In the ‘Workbook Views’ group click on ‘Page Layout’
  3. The Excel document will now be displayed on a virtual page – with a header and footer
  4. To edit the header/footer – click on ‘Add header’
  5. You can now add text and formatting to the header
  6. If you want to add “smart” parts such as the date, page number or file path – click on ‘Header & Footer Tools’ at the top of the window
  7. These are found in the ‘Header & Footer Elements’ group
  8. To return to the normal view – click on the ‘View’ ribbon, in the ‘Workbook Views’ group click on ‘Normal’



Reference: https://support.office.com/en-us/article/headers-and-footers-in-a-worksheet-cae2a88c-64a7-42ab-96a4-28d2fc16ad31

Tagged in

One comment on “Excel 2016 – How to edit worksheet header/footer

  1. Please, please, please, don’t tell me to go to the Insert Menu and click on Header and Footer. THERE IS NO HEADER/FOOTER OPTION IN MY INSERT MENU.
    Besides, I HAVE a header already in place! I want to change it! It has three boxes, I want two. It has a right aligned text situation. I want the text to be Left aligned. Also, it is too wide, and does not align with the page margins! I want to make it do so. I already have checked the option to flow with the page margins, when I can find that option!~ Keeps disappearing! Let’s just start with that! No instructions that I find, even inside the program match what I”m seeing! And I can’t get anyone to assist me!

Leave a Comment

Your email address will not be published. Required fields are marked *