Excel 2010 Bible

Chapter 9: Printing Your Work

185

Printing row and column headers ...........................................................................

By default, row and column headers for a worksheet are not printed. If you want your printout to

include these items, choose Page Layout ➪ Sheet Options ➪ Headings ➪ Print.

Using a background image ......................................................................................

Would you like to have a background image on your printouts? Unfortunately, you can’t. You may

have noticed the Page Layout ➪ Page Setup ➪ Background command. This button displays a dialog

box that lets you select an image to display as a background. Placing this control among the other

print-related commands is very misleading. Background images placed on a worksheet are never

printed.

Tip

In lieu of a true background image, you can insert a Shape, WordArt, or a picture on your worksheet and then

adjust its transparency. Then copy the image to all printed pages. Alternatively, you can insert an object in a

page header or footer. See the sidebar titled, “Inserting a Watermark.” n

Adding a Header or Footer to Your Reports ......................................................................

A header is information that appears at the top of each printed page. A footer is information that

appears at the bottom of each printed page. By default, new workbooks do not have headers or

footers.

You can specify headers and footers by using the Header/Footer tab of the Page Setup dialog box.

This task is much easier if you switch to Page Layout view, though, where you can click the section

labeled Click to Add Header or Click to Add Footer.

Note

If you’re working in Normal view, you can choose Insert ➪ Text ➪ Header & Footer. Excel switches to Page

Layout view and activates the center section of the page header. n

You can then type the information and apply any type of formatting you like. Note that headers

and footers consist of three sections: left, center, and right. For example, you can create a header

that prints your name at the left margin, the worksheet name centered in the header, and the page

number at the right margin.

Tip
If you would like a consistent header or footer for all your documents, create a book.xlt with your headers
or footers specified. A book.xlt template is used as the basis for new workbooks. See Chapter 8 for details. n