Printing Headers and Footers

graphics/10inf12.jpg

graphics/one_icon.jpg

Open the View menu and select Header and Footer to open the Page Setup dialog box with the Header/Footer tab displayed.

graphics/tow_icon.jpg

Click the down arrow next to the Header field and scroll through the header options. If you see one you like, click it to see what it looks like.

graphics/three_icon.jpg

Click the down arrow next to the Footer field and scroll through the footer options. If you see one you like, click it to see what it looks like.

graphics/foure_icon.jpg

Click OK. If you want, you can view the worksheet in Print Preview mode to get an idea of what your printed worksheet will look like with headers and footers.

INTRODUCTION

Headers and footers appear at the top and bottom of printed pages of Excel worksheets. They can display the filename, the date and time the worksheet was printed, the worksheet's name, the page number, and more. Excel offers many standard headers and footers, or you can create custom headers and footers.

TIP

Creating Custom Headers and Footers

You can create your own custom header or footer by clicking Custom Header or Custom Footer in the Page Setup dialog box. A separate Header or Footer dialog box appears, allowing you to click a button to place text or the following fields in the header/footer: Page Number, Total Pages Number, Date, Time, Path & Filename, Filename Only, Tabs, and Insert Graphic Objects. You can add page numbers and the total page count to the header or footer. Clicking the appropriate button inserts the field codes so "&[Page] of &[Pages]" displays as "Page 1 of 2".



Easy Microsoft Office 2003
Easy Microsoft Office 2003
ISBN: 0789729628
EAN: 2147483647
Year: 2003
Pages: 281
Authors: Nancy Lewis

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net