➔For a detailed discussion of workbook scenarios, see “Storing Multiple Scenarios in a Single Workbook,”
p. 829.
Troubleshooting
Editing an Array Formula
I entered an array formula, but when I try to edit or copy it, the results change or I 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
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.