"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.

• 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.

• 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

• From the View tab, in the Workbook Views group, click the Page Layout icon.
• Edit or change the elements in the header or footer as you wish.
• When finish, just press the Esc key and save your work.


Related Topics:

How to Edit Cell in Excel 2007 and How to Prevent it from Editing?
Discovering the Cells Alignment Options in Microsoft Excel 2007
How to Merge and Unmerge Cells in Excel 2007?
Formatting Number in Excel 2007



Can't find what you're looking for? Try Google Search!


Custom Search


Back to Top

You're viewing the Excel Header and Footer info page, click here to go back to the Home Page

Add To Your Social Bookmarks: Blink Del.icio.us Digg
Furl Google Simpy Spurl Technorati Y! MyWeb