• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Troubleshooting

Editing an Array Formula

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

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 array formula, you'll get an error message; select a new destination range, or use AutoFill to copy the formula. Oh, and don't try to cheat by adding your own curly braces to create an array formula—the only way to enter an array formula is to press Ctrl+Shift+Enter and let Excel add the curly braces.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint