Microsoft KB Archive/215514

From BetaArchive Wiki
Knowledge Base


XL2000: Inconsistent Results When You Press CTRL+ENTER to Replace Formatting in a Selected Range

Article ID: 215514

Article Last Modified on 9/27/2003



APPLIES TO

  • Microsoft Excel 2000 Standard Edition



This article was previously published under Q215514

SYMPTOMS

In Microsoft Excel, when you select a range of cells and then apply the value and the formatting of one cell to the range of cells by pressing CTRL+ENTER, the value is entered as expected, but the formatting results may vary, depending on which cell applies the formatting.

CAUSE

This behavior can occur because the process for applying the format of a single cell to a range of cells does not function as expected.

WORKAROUND

To work around this issue, format your intended range of cells by using the Cells command on the Format menu.

STATUS

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


Additional query words: XL2000

Keywords: kbbug kbpending KB215514