① opens the EXCEL2010 Worksheet window and switches to the view ribbon. In the workbook view group, click the Page Layout button.
② at the top of the EXCEL2010 worksheet page, click the "click to add Header" text tip to enter the header text directly, and you can format text in the start Ribbon. Single-click the Header and Footer tool design ribbon to insert controls such as page numbers, footers, pictures, or the current time. In addition, you can also set the "home page is Different", "odd and even different" options.
③ by default, clicking the entered header text directly at the top of the page is centered. Users can click the left and right text boxes in the default header position to insert a header to the left or right of the top of the page. The way to insert a footer on a Excel2010 worksheet is exactly the same as inserting the header.