Paul Wherly

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

ExcelDifHead1

  1. Ensure you are in headers or footers
  2. On the Header & Footer Tools tab, click on the Different Odd & Even Pages checkbox
  3. 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)
  4. Click into the main part of the spreadsheet to return to Normal view

Different Header and Footer on the First Page

ExceDifHead2

  1. Ensure you are in headers or footers
  2. On the Header & Footer Tools tab, click on the Different First Page checkbox (1)
  3. Add your different header and footer elements to the First page (Excel tells you when you are in the First PageHeader) (2)
  4. Add your header and footer elements to your second page – these will recur throughout the rest of your workbook
  5. Click into the main part of the spreadsheet to return to Normal view
[callout]To learn more about Footers and Headings and to see how we can help your organisation improve their performance with Microsoft Excel give us a call 020 8203 1774[/callout]

Shelley Fishel

Contact us

Would you like to talk through your IT Training needs?
Just send through your details and we'll get back to you.

More