"Excel Header and Footer: How to Add it to the Excel 2007 Worksheets?"

The Excel header and footer are lines of text that print at the top (header) and bottom (footer) of each page in the spreadsheet.

Normally we type in descriptive text to add information to a spreadsheet such as titles, dates, page numbers, etc.

A header or footer can appear in three locations on the page. It can be in the top/bottom left corner, the center, and the right corner of the page.

With the latest version of Excel 2007, it is much simpler to add a header and/or footer to your worksheet. Here are the steps:


To insert header and footer

  • Click the View tab.
  • In the Workbook Views group, click the Page Layout icon.
  • Click in the area marked Click to add header.
  • Excel 2007 add header

  • Choose where you want the text to be, left, center or right aligned. In our example as shown above, it's center align.
  • Type the desired text in the appropriate box.
  • You also can use the Header & Footer Tools Design Tab, Header & Footer Elements group to insert the appropriate text.
  • Excel 2007 header and footer elements

  • If you wish to go to the footer, click on Go to Footer icon in the Navigation group.
  • Click the Home tab to apply formatting to the text (font, bold, underline, or color).


To view header and footer

  • Headers and footers are not visible in the normal worksheet view.
  • You can use the Page Layout view to see the headers and footers.
  • To view a header or footer before printing the spreadsheet, use the Print Preview option (Office button - Print).


To edit the excel header and footer

Google Search:

Custom Search

Recommended Books:

Click on the image to view the details of the book.
Excel 2007 ebook
The Ultimate Guide to
Excel 2007!


PowerPoint 2007 ebook
The Ultimate Guide to
PowerPoint 2007




XML RSS
What is this?
Add to My Yahoo!
Add to My MSN
Add to Google


Enjoy This Site?
Then why not use the button below, to add us to your favorite bookmarking service?

Copyright © www.msoffice-tutorial-training.com. All Rights Reserved.