How to insert header and footer in Excel 2010

Microsoft Excel 2010 provides option for inserting header and footer for Worksheets. This can be done using the Page Layout option.

Click on the View menu and then select Page Layout option.


The following Page Layout view will be displayed.


click the Click to add header text and enter the Header for the Worksheet like Personal Finance


Now scroll to the bottom of the page and using the Click to add footer text you can enter footer for an Excel Page.


In Category: Excel 2010, Office 2010

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

Show 5 Comments
  • Elizabeth Jessop February 6, 2012, 7:26 pm

    how do I make the header / footer not visible on the page while typing?

  • TOM L June 13, 2012, 8:26 pm

    can you move header

  • Ray June 23, 2012, 7:20 am

    OK Now I inserted it butI was to change some wording and I cannot navigate back to do so

  • BUtter July 18, 2012, 4:34 am

    My footer is starting with zero. Why?
    I want it to start with one.

  • Ravi Shankar July 19, 2012, 1:35 pm

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.