LyteByte

Working with header and footer in Excel from Office 2007 has gotten much simpler and more sophisticated with varied options. Lets see all the features of header and footer in Excel 2007. If you are new to the feature of Headers and Footers, they are the information displayed on the top and bottom of page when an Excel sheet is printed. This allows to display any titles or page numbers when they are printed.

How to Insert Header and Footer in Excel from Office 2007?

Go to Insert tab and click Header & Footer under Text.

Now the layout of the sheet maybe changed to Page Layout from Normal spreadsheet layout.

Now there are three sections of header and footer, left, center and right. Click on each section and begin typing the details that you want to appear on the header.

To format any section, just highlight the section and click the Home tab. Use the options under Font to format as per need with change in font size, color, bold, italic, underline etc.

To change other options in header and footer, you can find those features under the new tab Header and Footer Tools –> Design.

Lets see one by one all the features in the header and footer design tools.

You can choose various templates of header and footer from the first left most header and footer menu.

While inserting header and footer, you can navigate between them using the Navigation menu under Header & Footer Design tab. This allows to switch between header and footer and edit them.

You can also insert various header and footer elements like Page numbers, Number of pages, Current Date, Current Time, File Path, File Name, Sheet name and picture.

You can also change other options like have different header and footer in first page of the Excel sheet, Different for odd and even pages, scale with document, align with page margins.

Now to preview how the header and footer looks like you can use the print preview feature all the pages.

After inserting the header and footer, the layout of the sheet will be changed to Page Layout. If you want to change the layout view go to View tab and click Normal.

Check this post if you are looking for How to Insert Same Header and Footer in all sheets under Excel 2007?