Microsoft KB Archive/109571

{|
 * width="100%"|

XL5: Array Formula Fills Range When Entered in Single Cell

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, version 5.0

-

SYMPTOMS
In Microsoft Excel, if you fill a formula across a range of cells, and then enter an array formula in one of the cells in the range, the contents of every cell in the filled range except the first cell is replaced by the array formula.

WORKAROUND
To enter an array formula in a cell that is part of a filled formula range and have the array contained only in that cell, do either one of the following:


 * If you don't need to keep the contents of the cell into which you want to enter an array formula:


 * Select the cell that you want to enter an array formula into, and from the Edit menu, choose Clear.
 * If you do need to keep the contents of the cell into which you want to enter an array formula:


 * Select the cell that you want to enter an array formula into, and from the Edit menu, choose Cut.
 * Select an empty cell on the worksheet, and from the Edit menu, choose Paste.
 * Select the pasted cell, and from the Edit menu, choose Cut.
 * Select the original location of the cell, and from the Edit menu, choose Paste.

STATUS
This problem was corrected in Microsoft Excel for Windows 95, version 7.0.