MacXLX: Excel Sets the Default Header or Footer Font to Zero Size

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.


When you click Custom Header or Custom Footer on the Header/Footer tab of the Page Setup dialog box, and then click the Font button, Excel sets the default font to Lucida Grande and the default size to 0 (zero).

If you then try to change the font without first selecting a font size, you receive the following warning message:
Font size must be between 1 and 409.


This problem occurs if the active field in the Header or Footer dialog box is empty when you click the Font button. (The active field is denoted by an outline and contains a blinking insertion point.)


To work around this problem, type some text in the header or footer and select it before you click the Font button. If you do this, Excel sets the default font to Verdana and the default size to 10.


Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

More Information

You cannot set a font size to zero. If you attempt to do this in the Font dialog box, you receive the error message in the "Symptoms" section of this article.


Article ID: 312260 - Last Review: Jan 31, 2007 - Revision: 1