Microsoft Office Tutorials and References
In Depth Information
Headers and Footers—Getting to the Bottom (and the Top) of Your Printout
Note the instructions contained in the dialog box as well. The buttons are more-or-less organized
in groups, as you see here, surrounded by the ovals. If you want to enter your own text header, just click
in the appropriate section above and start typing. To format the text, just select what you’ve written,
click the A button , an d se l e ct the fon t an d i ts si ze . T he n e xt two button s whe n cl i cke d post page
references in the form of codes—page number and number of pages in the printout, respectively. You
can enter both in one section, and insert the word “of” between the codes, thus yielding 1 of 2, 2 of 2,
e tc. T he n e xt two button s i n se r t date an d ti me codes. T i me i n se r ts an updatabl e cur r e n t- ti me code ,
such that whenever you print the document the correct time will appear on the printout and/or Print
Preview. The next three buttons will insert the file path (e.g., c:\My
Documents\SampleSalespersonReport.xlsx—often used in offices, so that other employees will be able
to locate the workbook), the file name, and the sheet (tab) name. The last buttons will, when clicked, let
you insert a picture in the header or footer, and allow you to edit it with assorted picture tools (enabled
by the very last button).
For example, if I type my company name in the left header section, enter today’s date in the center
(whenever that is), and the page number in the right, these selections will look like this, as Excel codes
them (Figure 9-12):
Figure 9–12. Three header entries, one in each section
Click OK and these elements will appear in your header. Needless to say, all these options can be
applied to footers as well. You can easily see how it all looks by clicking the Print Preview button in the
Page Setup dialog box, or even by just viewing the small preview screens in the Page Setup
Header/Footer tab.
You’ll also note four check box options on the Header/Footer tab. Different odd and even pages lets
y ou suppl y di ffe r e n t he ade r s an d/or foote r s for odd an d e v e n pag e s. By che cki n g that box an d the n
clicking Custom Header or Footer, you’re brought to a slightly changed dialog box (Figure 9-13):
 
Search JabSto ::




Custom Search