View Other Header and Footer Options

1. Choose View => Worksheet Views => Page Layout View.
2. Choose Header and Footer Tools Design. From the Options group, select any of the options:
   
   
   
   
   
   Different first page:
   For the first time in Excel history, you can now define a header or footer for the first page that's different from all the rest of the pages. Simply, click the Different First Page check box to put a check mark in it. If you choose this option, Excel won't print the header or footer on the first page.
   
   After selecting the Different First Page check box, go ahead and define the unique header and/or footer for just the first page (now marked First Page Header or First Page Footer) and then, on the second page of the report, define the header and/or footer (marked simply Header or Footer) for the remaining pages of the report.
   
   Use this feature when your spreadsheet report has a cover page that needs no header or footer. For example, suppose that you have a report that needs the current page number and total pages centered at the bottom of all pages except the cover page. To do this, select Different First Page check box on the Design tab of Header & Footer Tools contextual tab on the Ribbon and then define a centered Auto Footer that displays the current page number and total pages (Page 1 of ?) on the second page of the report, leaving the Click to Add Footer text intact on the first page.
   
   Excel will correctly number both the total number of pages in the report and the current page number without printing this information on the first page. So if your report has a total of six pages (including the cover page), the second page footer will read Page 2 of 6; the third page, Page 3 of 6; and so on, even as the first printed page has no footer at all.
   
   Different odd and even pages:
   If you plan to do two-sided printing or copying of your spreadsheet report, you may want to define a one header or footer for even the pages and another for odd pages of the report. That way, the header or footer information (such as the report name or current page) alternates from being rightaligned on the odd pages (printed on the front side of the page) to being left-aligned on even pages (printed on the back side of the page).
   
   To create an alternating header or footer for a report, you click the Different Odd and Even Pages check box to put a check mark in it.
   
   After that, create a header or footer on the first page of the report (now marked Odd Page Header or Odd Page Footer) in the third, right-aligned section header or footer area and then recreate this header or footer on the second page (now marked Even Page Header or Even Page Footer), this time in the first, left-aligned section.
   
   Scale with document:
   This option is selected by default and tells Excel to use the same font size and scaling as the worksheet. If you want the header and footer font size and scaling independent of the worksheet scaling, clear this check box.
   
   Align with page margins:
   Choose this option to align the header and footer with the left and right margins of the worksheet.