Article ID: 214054 - View products that this article applies to.
This article was previously published under Q214054
In Microsoft Excel, you may receive the following error message
when you attempt to edit one of the cells that make up an array formula.
Cannot change part of an array
To cancel the error message, click OK, and then click the Cancel (X) button on the Formula Bar, or press ESCAPE.
To determine which cells make up the array, use either of the following methods to highlight the range that makes up the array formula.
Method 2Press CTRL+SHIFT and double-click any cell that is part of the array.
NOTE: After selecting the entire range that contains the array formula, you can edit the formula and press CTRL+SHIFT+ENTER to re-enter the array formula.
Contact us for more help
Connect with Answer Desk for expert help.