Page 16 of 23PREVNEXT

So that's how! Printing options in Excel

Header, Custom Header, Footer, Page Number, Date, listed on page

Headers and footers say what you want them to say.

Like titles and headings, page numbers help people find their way around longer printouts. Excel can add page numbers automatically, top or bottom, as headers or footers.

Do you want to take credit for your data? You can also use headers and footers to identify the worksheet. Dates are always helpful — it's good to see when data was printed. Company name? Time the worksheet was printed? It's up to you.

To create headers and footers, if you're looking at the worksheet in print preview, click Setup. Or in normal view, click the File menu and then click Page Setup. In the Page Setup dialog box, click the Header/Footer tab.

Click the arrow next to the Header box or the Footer box and choose from the list you see. You could select Page 1 and the name of the worksheet. Or you could enter your name, the page number, and the date. (If you decide later that you don't want a header or a footer, go back and select None.) If you want both a header and a footer, click the other arrow and choose from that list.

If you want a little more in your header or footer, click Custom Header or Custom Footer. You can type whatever you want, add a picture, or change the font used in the header or footer. Note that after you create a custom header or footer, it is added to the list of the standard headers and footers. You'll see to create headers and footers in the practice.

Page 16 of 23PREVNEXT