Insert a Header or Footer in Excel

Who else wants to know the secret to Excel Formulas?

Invest in yourself in 2015 and reduce your frustration with formulas in Excel for just $19.95 - Click here to enroll today

Just like a header or footer in Word 2007, you can quickly add a header or footer to a workbook in Excel 2007.  You can add the date, time, filename or any other information you would like to make available to readers of your spreadsheet.

To create a header or footer in Excel 2007, Excel 2010 or Excel 2013:

1) Make sure you are on the “Insert” tab of the ribbon

2) Look for the “Text” group – it will be on the right hand side of the ribbon

3) Click on “Header & Footer”

You will see a new tab appear on the ribbon called “Header & Footer Tools – Design”.  Using the buttons on this tab of the ribbon, you can quickly add:

  • Page Number;
  • Number of Pages;
  • Current Date;
  • Current Time;
  • File Path;
  • File Name;
  • Sheet Name; or a
  • Picture

To the header or footer of your document.  To switch from the header to the footer, simply click on “Go to Footer” which you will find in the “Navigation” group about half way along the ribbon.

‘till next time!

2 thoughts on “Insert a Header or Footer in Excel

  1. I know you can get the Header & Footer Tools Design ribbon to appear as described. How do you get it to go away??? I have to start to close the document and cancel, which seems silly.

  2. I got the answer. The advice to change view to Normal view was not working till I clicked out of the header (or footer) cell to a regular cell. Then I could click on Normal view icon and be back to normal.

Leave a Reply

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