Excel: How To Add Headers and Footers to Your Worksheets

Previous versions of Excel required you to utilize a dialog box to add or modify the header and footer. With newer versions of Excel, it is much simpler to add a header and/or footer to your worksheet. This method works for Excel 2007, 2010, and 2011 for Mac.

In Excel, you can place a header and footer upon your worksheet to add extra information and assist with sorting. Often page numbers, dates, categories are included. Headers and footers can be located on the left, middle or center of the page.

Excel 2007 and 2010

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).

Excel 2011

1. Select the Layout tab

2. Click Header & Footer

3. Customize the header information in the dialog box that appears.

Alternatively, you can also manually insert a header or footer by clicking at the blank area at the top or bottom of the page while your are viewing from Layout -> Page Layout mode.

manual add header in page layout mode

 

About Aaron St. Clair

Aaron St. Clair is a tech guru studying Computer Science at Appalachian State University in Boone, North Carolina. When he's not tinkering with new gadgets, modding systems, or slaving away at the mercy of the Tech-Recipe overlords, you can find him exploring the high country.
View more articles by Aaron St. Clair

The Conversation

Follow the reactions below and share your own thoughts.

  • Ronica

    Why can’t you add an image to the header?

  • Mujeeb

    Can we add image to a header?

  • guru

    please tell me how to incert header and footer in excel 2013…
    I’m using 1 month trial version, i tried all my knowledge, but couldnt incert our logo(image) into header.. Please help…

    • http://www.tech-recipes.com/ Aaron St. Clair

      You’re right, 2013 does change the procedure a bit. In Excel 2013, click the View tab at the top, and the on the left of the ribbon, in the section called Workbook Views, you will see Page Layout. Click Page Layout to expose Headers/Footers on your document. Click in the header area, and click the tab at the top called the “Header & Footer Tools” Design tab. It’s not normally there, but once you click in the Header it will appear. In this tab’s ribbon, you have the option inside “Header & Footer Elements” to select a Picture. This should allow you to place your logo at the top.