The information in this article applies to:
SYMPTOMSIn 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:
-or- STATUSThis problem was corrected in Microsoft Excel for Windows 95, version 7.0. REFERENCESFor more information about Entering An Array Formula, choose the Search button in Help and type: array formulasFor more information about Filling A Range Of Adjacent Cells, choose the Search button in Help and type: filling Additional query words:
Keywords : |
Last Reviewed: September 22, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |