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.


Meet the Author

Ravi Shankar

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

5 comments… add one

  • Elizabeth Jessop Feb 6, 2012, 7:26 pm

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

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

    can you move header

  • Ray Jun 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 Jul 18, 2012, 4:34 am

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

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

Leave a Comment

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