XL5: Array Formula Fills Range When Entered in Single Cell

ID: Q109571

5.00 WINDOWS kbusage

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

   filling

Additional reference words: 5.00

Version           : 5.00
Platform          : WINDOWS

Last Reviewed: September 14, 1996