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. 
4. The Excel document will now be displayed on a virtual page – with a header and footer
5. To edit the header/footer – click on ‘Add header’
6. You can now add text and formatting to the header
7. 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
8. These are found in the ‘Header & Footer Elements’ group
9. 
10. To return to the normal view – click on the ‘View’ ribbon, in the ‘Workbook Views’ group click on ‘Normal’
11. 

 

 

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