Add a Header or Footer in Excel 2007

Previous versions of Excel required you to utilize a dialog box to add or modify the header and footer. With the new version of Excel, it is much simpler to add a header and/or footer to your worksheet.

Steps

  1. Click the View tab.
  2. Select Page Layout.
  3. Click in the area marked Click to add header or Click to add footer
  4. Choose where you want the text to be, left, center or right aligned.
  5. Type the desired text in the appropriate box.
  6. Click the Home tab to apply formatting to the text (font, bold, underline, or color).



Things You'll Need

  • Microsoft Excel 2007
  • A Computer running Windows

Related Articles