Microsoft KB Archive/151130

= Microsoft Knowledge Base =

XL: Accounting Underlines Cause Problems in Headers or Footers
Last reviewed: September 13, 1996

Article ID: Q151130

The information in this article applies to:


 * Microsoft Excel for the Macintosh, version 5.0
 * Microsoft Excel for Windows 95, version 7.0
 * Microsoft Excel for Windows, version 5.0

SYMPTOMS
When you modify the Normal style in a Microsoft Excel for Windows workbook, and then modify the font in a custom header or footer, the font dialog box may not appear.

In addition, when you modify the Normal style in a Microsoft Excel for the Macintosh workbook, and then modify a custom header or footer, Microsoft Excel may stop responding.

CAUSE
In Microsoft Excel for Windows, this behavior occurs when you change the Underline option to Single Accounting or Double Accounting in the workbook's Normal style, and you then attempt to change the font in a custom header or footer.

In Microsoft Excel for the Macintosh, this behavior occurs when you change the Underline option to Single Accounting or Double Accounting in the workbook's Normal style, you insert a code in a custom header or footer, and you then attempt to reinsert a code in the custom header or footer.

WORKAROUND
To work around this problem, reset the Underline option in the Normal style to None, and apply the Single Accounting or Double Accounting Underline format to individual cells, instead of redefining the worksheet style. To do this, follow these steps:


 * 1) On the Format menu, click Style.
 * 2) Click Modify, and then click the Font tab.
 * 3) Under Underline, select None, click OK, and click OK again.
 * 4) Select the cells that you want to format, and click Cells on the Format menu.
 * 5) Click the Font tab, and under Underline, select the Single Accounting or Double Accounting option, and then click OK.

STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION
Note that the Single Accounting and Double Accounting Underline options are not available in the Font dialog box when you click the Font button in a custom header or footer. Only Single or Double underline options are available when you click the Font button in a custom header or footer.