Different Headers and Footers in Microsoft Excel 2010
Quick Tip for Microsoft Excel 2010
Here is how you create different headers and footers in Microsoft Excel 2010
- Ensure you are in headers or footers
- On the Header & Footer Tools tab, click on the Different Odd & Even Pages checkbox
- Add your different header and footer elements to the odd and even pages (Excel tells you when you are in an Odd or Even PageHeader) (2)
- Click into the main part of the spreadsheet to return to Normal view
Different Header and Footer on the First Page
- Ensure you are in headers or footers
- On the Header & Footer Tools tab, click on the Different First Page checkbox (1)
- Add your different header and footer elements to the First page (Excel tells you when you are in the First PageHeader) (2)
- Add your header and footer elements to your second page – these will recur throughout the rest of your workbook
- Click into the main part of the spreadsheet to return to Normal view