Printing a Multi-Line Footer

Summary: Add a footer to your document and you may want to make it span more than a single line. This can be easy to do, provided you remember how to "break" the lines. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

Excel allows you to create headers and footers that you can use with your workbooks. If you want, you can create a multi-line header or footer, as desired. The trick is to remember that you cannot press Enter while typing your footer. Instead, to start a new line you should hold down the Alt key as you type 0010 on the numeric keypad. This inserts a line-break character in the footer text.

Another thing to remember when doing footers in this way is that you will need to increase the bottom margin on your page setup. If you fail to increase it sufficiently, your footer may "overprint" the data in your worksheet, or vice-versa.

Finally, you must keep in mind that Excel places a limit on the length of your headers and footers. The total length of a header or footer cannot exceed 255 characters. If you need to create a header or footer that contains more characters, you will need to create them differently, without explicitly doing so as a header or footer.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (1993) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

PivotTables Got You Perplexed? PivotTables for the Faint of Heart shows how you can start using Excel's PivotTable tool right away to spin your data into gold! You discover how easy it really is to crunch the numbers you need to crunch. Uncover the power of creating PivotTables, editing them, formatting them, customizing them, and much more.

Check out PivotTables for the Faint of Heart today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Printing a Multi-Line Footer