Download free ebooks – Windows 8, Mac OS X, MSOffice, Keynote, Nexus etc.

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.

image

The following Page Layout view will be displayed.

image

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

image

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

image

5 comments… add one
  • how do I make the header / footer not visible on the page while typing?

  • can you move header

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

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

Leave a Comment

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