Special Edition Using Microsoft® Office XP

Troubleshooting

Editing an Array Formula

Q1:

I entered an array formula, but when I try to edit or copy it, the results change or I get an error message.

A1:

Editing an array formula is tricky. If the array formula was entered across multiple cells, you must select every cell that contains the array before you can edit it. If the array formula is contained in a single cell, you can edit it just as you would a conventional formula, but you must remember to press Ctrl+Shift+Enter to store your changes as an array formula. If you forget and press Enter, Excel stores it as a standard formula, with the wrong results. Finally, you'll notice some restrictions when you try to copy an array formula. If the destination range you select also contains the ...