Click the Insert tab. Click the Header & Footer button.
![Click the Insert tab. Click the Header & Footer button.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Add_Predefined_Header_Or_Footer_In_Page_Layout_View___Click_Insert_Tab_Click_Header__Foot.PNG)
The worksheet appears in Page Layout view.
![The worksheet appears in Page Layout view.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Add_Predefined_Header_Or_Footer_In_Page_Layout_View___The_Worksheet_Appears_In_Page_Layou.PNG)
To insert predefined header and footer, click the Header or Footer button, and then click the setting.
![To insert predefined header and footer information, click the Header or Footer button, and then click the information.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Add_Predefined_Header_Or_Footer_In_Page_Layout_View___To_Insert_Predefined_Header_And_Foo.PNG)
After you make a selection, Excel exits the Design tab.
![After you make a selection, Excel exits the Design tab.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Add_Predefined_Header_Or_Footer_In_Page_Layout_View___After_You_Make_Selection_Excel_Exit.PNG)
To add more header or footer text,
click the left, center, or right header or footer boxes to place the insertion point.
![To add more header or footer text, click the left, center, or right header or footer boxes to place the insertion point.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Add_Predefined_Header_Or_Footer_In_Page_Layout_View___To_Add_More_Header_Or_Footer_Text_C.PNG)
To change a header or footer, select the current text. Type the text.
![To change a header or footer, select the current text. Type the text you want.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Add_Predefined_Header_Or_Footer_In_Page_Layout_View___To_Change_Header_Or_Footer_Select_C.PNG)
To start a new line in a header or footer text box, press Enter.
![To start a new line in a header or footer text box, press Enter.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Add_Predefined_Header_Or_Footer_In_Page_Layout_View___To_Start_New_Line_In_Header_Or_Foot.PNG)
To close the headers or footers, click anywhere in the worksheet.
![To close the headers or footers, click anywhere in the worksheet.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Add_Predefined_Header_Or_Footer_In_Page_Layout_View___To_Close_Headers_Or_Footers_Click_A.PNG)