Welcome toExcel.Tips.Net
Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Learn Access Now
Free Printable Forms
Beauty Tips
Car Tips
Cleaning Tips
Cooking Tips
ExcelTips (menu)
ExcelTips (ribbon)
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
School Tips
Wedding Tips
WordTips (menu)
WordTips (ribbon)
Advertise on the
ExcelTips Site
Working with Imperial Linear Distances
Incomplete and Corrupt Sorting
Quickly Removing a Toolbar Button
Deriving High and Low Non-Zero Values
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
Got the Time? Understanding the ins and outs of working with times and dates can be confusing. Remove the confusion--ExcelTips: Times and Dates is an invaluable resource for learning how best to work with times and dates.