Topic 13: How to add Header and Footer to the Spreadsheets?
 

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

<table width="550" border="0" cellpadding="8" cellspacing="0"><tbody><tr><td>Click the View tab.
In the Workbook Views group, click the Page Layout icon.
Click in the area marked Click to add header.

</td></tr></tbody></table>

<table width="550" border="0" cellpadding="8" cellspacing="0"><tbody><tr><td>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 ****on - Print).

</td></tr></tbody></table>