Excel 2010 Just the Steps For Dummies
Book image
Explore Book Buy On Amazon

Although Excel 2010 provides standard header and footer text that you can select from drop-down menus, you also can create a custom header or footer. In addition to typical header or footer items such as the page number, filename, and date or time, you can insert and format a picture. Also, you can format the text in a header or footer just as you would any cell data.

To create a custom header or footer in Excel 2010, follow these steps:

  1. Click the Page Layout button on the View tab of the Ribbon (or click the Page Layout View button on the Status bar).

  2. Position the mouse pointer over the Click to Add Header section at the top or the Click to Add Footer section at the bottom.

  3. Click to position the insertion point in the left, center, or right section of the header or footer area.

    Excel adds a Header & Footer Tools contextual tab with its own Design tab.

    With Excel 2010, you can create a custom header or footer in the worksheet.
    With Excel 2010, you can create a custom header or footer in the worksheet.
  4. Click the Design tab if it isn't already selected, and then click any option that you want to add in the Header & Footer Elements group:

    • Page Number: Insert a code that indicates the page number.

    • Number of Pages: Insert a code that indicates the total number of pages.

    • Current Date or Current Time: Insert the print date or time of day.

    • File Path, File Name, or Sheet Name: Include file information.

    • Picture: Insert a graphic image, such as a company logo.

    • Format Picture: Resize, rotate, or crop a header or footer graphic image.

      Use the buttons in the Header & Footer Elements group to create custom headers and footers.
      Use the buttons in the Header & Footer Elements group to create custom headers and footers.
  5. Repeat Steps 3 and 4 as needed, and also type any additional text you want for the header or footer.

    You can format the header and footer text just as you would any cell data.

  6. Click in the worksheet area and then click the Normal button on the View tab to return to Normal view.

About This Article

This article is from the book:

About the book author:

Diane Koers owns and operates All Business Service, a software training and consulting business formed in 1988, that services the central Indiana area. Her area of expertise has long been in the word-processing, spreadsheet, and graphics areas of computing. She also provides training and support for Peachtree Accounting Software. Diane's authoring experience includes over 40 books on topics, such as PC security, Microsoft Windows, Microsoft Office, Microsoft Works, WordPerfect, Paint Shop Pro, Lotus SmartSuite, Quicken, Microsoft Money, and Peachtree Accounting. Many of these titles have been translated into other languages, such as French, Dutch, Bulgarian, Spanish, and Greek. She has also developed and written numerous training manuals for her clients.
Diane and her husband enjoy spending their free time fishing, traveling, and playing with their four grandsons and their Yorkshire Terrier.

This article can be found in the category: