Results 1 to 4 of 4

Thread: How to add Header and Footer in Excel 2007

  1. #1
    Join Date
    Apr 2009
    Posts
    460

    How to add Header and Footer in Excel 2007

    I am not much familiar to MS Office 2007, and today i have to add a Header and Footer in one of the Excel worksheet. I need a urgent help from you all guys regarding the same as i have to present this file in my office. So please make me know how can i add Header and Footer in Excel 2007 ?

  2. #2
    Join Date
    May 2008
    Posts
    3,316

    Re: How to add Header and Footer in Excel 2007

    Headers and footers are often used to identify the document used to produce the report and to display the page numbers and the date and time of printing. Header is printed in the top margin and footer is a line of text that prints at the bottom of each page in the spreadsheet.Unless you specify , Excel does not automatically add either a header or footer to a workbook.So to insert header and footer, follow this simple steps:-
    1. Go to View tab.

    2. Now click the Page Layout icon in the Workbook Views group.

    3. Click in the area marked Click to add header.

    4. Choose where you want the text to be, left, center or right aligned.

    5. Now type the desired text in the appropriate box.

    6. You also can use the Header & Footer Tools Design Tab, Header & Footer Elements group to insert the appropriate text.

    7. If you wish to go to the footer, click on Go to Footer icon in the Navigation group.

    8. Click the Home tab to apply formatting to the text.



    Thats it..

  3. #3
    Join Date
    Jan 2008
    Posts
    3,755

    Re: How to add Header and Footer in Excel 2007

    Headers and footers are not visible in the normal worksheet view.To view it
    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

    If you need to return to normal vies just click on any cell in the worksheet to leave the footer area. Click on the View tab. Click on the Normal option in the ribbon.

  4. #4
    Join Date
    Feb 2009
    Posts
    253

    Re: How to add Header and Footer in Excel 2007

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

Similar Threads

  1. File Path insert on Header/Footer Office 2007
    By Allanoo in forum MS Office Support
    Replies: 1
    Last Post: 04-02-2013, 04:20 PM
  2. Replies: 2
    Last Post: 07-04-2010, 02:33 AM
  3. Header and Footer in OpenOffice
    By Miles Runner in forum Windows Software
    Replies: 5
    Last Post: 19-02-2010, 03:24 AM
  4. Header footer start on page 2
    By Jayden in forum Windows Software
    Replies: 2
    Last Post: 29-07-2009, 10:46 PM
  5. How do i edit header and footer of a PDF?
    By Hilda Thompson in forum Windows Software
    Replies: 4
    Last Post: 04-07-2009, 02:27 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,649,222.82647 seconds with 17 queries