3.11.2.Insert Elements in a Header or Footer in Page Layout View |
|
Click the Insert tab. Click the Header & Footer button.
|
|
![Click the Insert tab. Click the Header & Footer button.](../../Microsoft-Office-Excel-2007Images/Insert_Elements_In_Header_Or_Footer_In_Page_Layout_View___Click_Insert_Tab_Click_Header__Foot.PNG) |
The worksheet appears in Page Layout view.
Click the left, center, or right header or footer text.
|
|
![Click the left, center, or right header or footer text.](../../Microsoft-Office-Excel-2007Images/Insert_Elements_In_Header_Or_Footer_In_Page_Layout_View___Click_Left_Center_Or_Right_Header_O.PNG) |
Click the Design tab under Header & Footer Tools.
|
|
![Click the Design tab under Header & Footer Tools.](../../Microsoft-Office-Excel-2007Images/Insert_Elements_In_Header_Or_Footer_In_Page_Layout_View___Click_Design_Tab_Under_Header__Foot.PNG) |
To insert individual elements, click the button in the Header & Footer Elements group.
|
|
![To insert individual elements, click the button in the Header & Footer Elements group.](../../Microsoft-Office-Excel-2007Images/Insert_Elements_In_Header_Or_Footer_In_Page_Layout_View___To_Insert_Individual_Elements_Click.PNG) |
Select or clear Different First Page to add or remove headers and footer from the first page.
|
|
![Select or clear Different First Page to add or remove headers and footer from the first page.](../../Microsoft-Office-Excel-2007Images/Insert_Elements_In_Header_Or_Footer_In_Page_Layout_View___Select_Or_Clear_Different_First_Pag.PNG) |
Select Different Odd &
Even Pages to have different header or footer for odd and even pages.
|
|
![Select Different Odd & Even Pages to have different header or footer for odd and even pages.](../../Microsoft-Office-Excel-2007Images/Insert_Elements_In_Header_Or_Footer_In_Page_Layout_View___Select_Different_Odd__Even_Pages_To.PNG) |
Select Scale with Document to use the same font size and scaling as the worksheet.
|
|
![Select Scale with Document to use the same font size and scaling as the worksheet.](../../Microsoft-Office-Excel-2007Images/Insert_Elements_In_Header_Or_Footer_In_Page_Layout_View___Select_Scale_With_Document_To_Use_S.PNG) |
Select Align with Page Margins to align header or footer margin with page margins.
|
|
![Select Align with Page Margins to align header or footer margin with page margins.](../../Microsoft-Office-Excel-2007Images/Insert_Elements_In_Header_Or_Footer_In_Page_Layout_View___Select_Align_With_Page_Margins_To_A.PNG) |
To close the headers or footers, click anywhere in the worksheet.
|
|
![To close the headers or footers, click anywhere in the worksheet.](../../Microsoft-Office-Excel-2007Images/Insert_Elements_In_Header_Or_Footer_In_Page_Layout_View___To_Close_Headers_Or_Footers_Click_A.PNG) |
Use two ampersands (&&) to enter an & in a header or footer |