How do I add a border to a header and footer in Excel 2007 or Excel 2010

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

. If you want to change the layout view go to

tab and click