How to 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. Image titled Add a Header or Footer in Excel 2007 Step 1
    1
    Click the View tab.
  2. Image titled Add a Header or Footer in Excel 2007 Step 2
    2
    Select Page Layout.
    Advertisement
  3. Image titled Add a Header or Footer in Excel 2007 Step 3
    3
    Click in the area marked Click to add header or Click to add footer
  4. Image titled Add a Header or Footer in Excel 2007 Step 4
    4
    Choose where you want the text to be, left, center or right aligned.
  5. Image titled Add a Header or Footer in Excel 2007 Step 5
    5
    Type the desired text in the appropriate box.
  6. Image titled Add a Header or Footer in Excel 2007 Step 6
    6
    Click the Home tab to apply formatting to the text (font, bold, underline, or color).
    7. Advertisement

Things You'll Need

  • Microsoft Excel 2007
  • A Computer running Windows

You Might Also Like

Add a New Tab in Excel
How to
Add a New Tab in Excel
Calculate the Day of the Week in Excel
How to
Calculate the Day of the Week in Excel
Recover a Corrupt Excel File
How to
Recover a Corrupt Excel File
Edit Data in Microsoft Excel
How to
Edit Data in Microsoft Excel
Create an Excel Financial Calculator
How to
Create an Excel Financial Calculator
Create a Mortgage Calculator With Microsoft Excel
How to
Create a Mortgage Calculator With Microsoft Excel
Make a Spreadsheet in Excel
How to
Make a Spreadsheet in Excel
Unprotect an Excel Sheet
How to
Unprotect an Excel Sheet
Create a Timeline in ExcelHow to Create a Timeline in Excel: SmartArt, Templates, and More
Create a Graph in Excel
How to
Create a Graph in Excel
Change from Lowercase to Uppercase in Excel
How to
Change from Lowercase to Uppercase in Excel
Merge Cells in ExcelHow to Merge Cells in Microsoft Excel: A Quick Guide
Insert Pictures in Excel That Automatically Size to Fit Cells
How to
Insert Pictures in Excel That Automatically Size to Fit Cells
How to
Unhide Rows in Excel
Advertisement

About This Article

wikiHow is a “wiki,” similar to Wikipedia, which means that many of our articles are co-written by multiple authors. To create this article, 11 people, some anonymous, worked to edit and improve it over time. This article has been viewed 68,269 times.
How helpful is this?
Co-authors: 11
Updated: June 4, 2020
Views: 68,269
Categories: Microsoft Excel
Advertisement