Carol's Corner Office

Adding headers to your worksheets in version 2007 of MS Excel is quite a bit different than what you are accustomed to in earlier versions.

You will no longer use a separate page to set up your headers as you did previously. MS Excel 2007 now allows you to work with your header directly in your Worksheet Layout view.

Follow along with this exercise to learn how to create your custom headers in MS Excel 2007.

Let’s create a header for your worksheet with the title “2008 Sales Forecast” in the center, with your company’s logo in the left-hand margin and the date in the right-hand margin.

Follow the steps below to learn how:

1. Click the View tab and then click Page Layout in the Workbook Views group.
2. Click the words Click to Add Header above row 1.
3. Key in the text “Sales Forecast.”
4. It is important to note that if there is an ampersand in your title (&), you must key in two of them so that Excel will recognize it as a character.
5. Click in the space to the left of the title.
6. In Header & Footer Design Ribbon, click Picture in the Header & Footer Elements group.
7. Navigate to the file containing your company’s logo
8. Highlight the logo and click Insert.
9. Click any cell in the worksheet.
10. Click on the logo.
11. In Header & Footer Tools Design Ribbon, select Format Picture in the Header & Footer Elements group.
12. Click the Down arrow of the Height box until it reaches 50%.
13. Click OK.
14. Click to the right of the worksheet title near the right margin.
15. Click Current Date in the Header & Footer Elements group of the Header & Footer Tools Design tab.
16. Click in any cell to exit.

This is a lot easier than in earlier versions!

Tags: current, date, design, Excel 2007, footer, header, layout, tab, worksheet

This entry was posted on Wednesday, August 6th, 2008 at 4:00 pm and is filed under Excel 2007. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.