Brother International PDP350CJ Owner's Manual - English - Page 179

Using Headers and Footers Headers and footers are the text that prints at the top or bottom of each page. Headers appear at the top of the page, and footers appear at the bottom. They can be as simple as the page number, or they can include more descriptive information, such as the following: It is a good idea to enter the text for headers and footers in cells that are not part of the main information in your spreadsheet. Then, when you print the spreadsheet, select a print range that excludes the cells containing the header and footer text. S Date the document was created or printed S Page number S Name of the document S Your name or the name of your department, business, or school S Graphics such as a a logo or drawing You can specify that Spreadsheet use text you have entered in a cell as the header or footer of the spreadsheet when it is printed. The text appears in the cell and as the header or footer. You may also create page numbers that automatically number themselves by typing in the page number function formula. See page 369 for the page numbering function. Be sure to choose the "=" to start your page formula. "To create a header or footer: 1. Enter the header text or footer in a cell or range of cells. 2. Select the cell or range. 3. Choose Header/Footer from the Cell menu. A submenu appears. 4. Choose either Set Header or Set Footer from the submenu. The selected information will print at the top or bottom of the page, as you have indicated. "To number pages consecutively: 1. Select the footer cell that you created above. 2. Under the Formula menu, choose Insert Function. 3. Select Print from the box on the left, and Page in the box on the right. 4. Select Paste. The formula is pasted in the text entry box. 5. Press ENTER. Your pages will be automatically numbered. 6. Click on Close. This exits you from the footer edit bar. You may want to choose a number format for your page number. Using Tones You can use tones or shades of gray to add interest to your spreadsheet presentation. You can use tones for the following elements in a spreadsheet: S Text S Background S Cell borders Tones also can be used with graphics and charts in Spreadsheet. See page 179 and page 182 for information on using tones with charts. See Drawing, Chapter 5, for information on using tones with graphics. Spreadsheet 165