Microsoft Office Tutorials and References
In Depth Information
You can also create custom headers by typing your own text or by using the commands
in the Header & Footer Elements group to insert a date, time, worksheet name, or page
number. You can also add a graphic, such as a company logo, to a worksheet. By adding
graphics, you can identify the worksheet as referring to your company and help reinforce
your company’s identity if you include the worksheet in a printed report distributed
outside your company. After you insert a graphic into a header or footer, the Format Picture
button in the Header & Footer Elements group will become available. Clicking that button
opens a dialog box with tools for editing your graphic.
In this exercise, you’ll create a custom header for a workbook. You’ll add a graphic to the
footer and then edit the graphic by using the Format Picture dialog box.
SET UP You need the RevenueByCustomer_start workbook and the
ConsolidatedMessenger image located in your Chapter11 practice file folder
to complete this exercise. Start Excel, open the RevenueByCustomer_start
workbook, and save it as RevenueByCustomer . Then follow the steps.
1. On the Insert tab, in the Text group, click Header & Footer .
Excel displays your workbook in Page Layout view.