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


The information in this article applies to:

  • Microsoft Excel 2000
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.
Modification Type:MajorLast Reviewed:9/27/2003
Keywords:kbbug kbpending KB215514
©2003 Microsoft Corporation. All rights reserved.