O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Adding Headers and Footers

Headers and footers are lines of text that you can print at the top and bottom of every page in a print job—headers at the top, footers at the bottom. You can include any text, the current date and time, or the filename, and you can even format the information in a header and footer. Excel also gives you a variety of preset headers and footers to choose from in case you don't want to create your own.

Using Excel's Preset Headers and Footers

Because a workbook can contain multiple worksheets, you might need to reference a cell in another worksheet, or even another workbook file. No problem! As long as you follow the proper syntax, you can type a formula that contains a reference to any file.

Figure 7.5 shows you what ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required