Go Back   Wiki NewForum > Career Forum > Tech Forum & Tutorial > IT Forum > MS office Tutorials (2003 & 2007) > MS Excel 2007

Sponsored Links

MS Excel 2007 Step-by-step Excel 2007 Tutorials, Tips and Training!"

Views: 689  
Thread Tools Rate Thread Display Modes
Old 01-27-2010, 01:06 PM
seema seema is offline
Join Date:
Oct 2009
Posts: 5,551
Default 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

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

Reply With Quote
Old 01-27-2010, 01:08 PM
seema seema is offline
Join Date:
Oct 2009
Posts: 5,551

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

Reply With Quote

New topics in MS Excel 2007

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2019, vBulletin Solutions, Inc.