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

Article translations Article translations
Article ID: 312260 - View products that this article applies to.
This article was previously published under Q312260
Expand all | Collapse all

SYMPTOMS

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.

CAUSE

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.)

WORKAROUND

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.

STATUS

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.

Properties

Article ID: 312260 - Last Review: January 31, 2007 - Revision: 1.1
APPLIES TO
  • Microsoft Excel X for Mac
Keywords: 
kbbug kbpending KB312260
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.

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com