Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
With more than 35 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company.
Learn more about Allen...
When you create an Excel worksheet, you have the ability to change the margins used when the information in the worksheet is printed. This is done by choosing Page Setup from the File menu, then making adjustments on the Margins tab. The default left and right margin values are .75 inches, unless you change them as described in other issues of ExcelTips.
When you change the left and right margin values, and even if you change the default left and right margin values, there is no way to modify the left and right margins used by Excel to print headers and footers. These are apparently hard-wired to print at .75 inches, regardless of the settings you make within the Page Setup dialog box. They cannot even be changed via VBA.
Further information on this issue can be found in Microsoft's Knowledge Base:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2191) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003
You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Setting Header/Footer Margins.
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!