XL5: Array Formula Fills Range When Entered in Single Cell

ID: Q109571


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:

    1. Select the cell that you want to enter an array formula into, and from the Edit menu, choose Clear.




  • -or-

  • If you do need to keep the contents of the cell into which you want to enter an array formula:

    1. Select the cell that you want to enter an array formula into, and from the Edit menu, choose Cut.


    2. Select an empty cell on the worksheet, and from the Edit menu, choose Paste.


    3. Select the pasted cell, and from the Edit menu, choose Cut.


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


REFERENCES

For more information about Entering An Array Formula, choose the Search button in Help and type:

array formulas
For more information about Filling A Range Of Adjacent Cells, choose the Search button in Help and type:
filling

Additional query words:

Keywords :
Version : 5.00
Platform : WINDOWS
Issue type :


Last Reviewed: September 22, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.