In Microsoft Excel, you may receive the error message "Cannot change part
of an array" when you attempt to edit one of the cells that make up an
To cancel the error message, click OK, and then click the "X" button in
the formula bar (or press ESC).
To determine which cells make up the array, use either of the following
methods to highlight the range that makes up the array formula:
- Choose one of the cells that you know is in the array formula. On the
Formula menu, click Select Special, and then click Current Array. In
Microsoft Excel versions 5.0 and later, follow these steps:
1. On the Edit menu, click Go To. Or, press F5.
2. In the Go To dialog box, click Special.
3. In the Go To Special dialog box, click Current Array, and then
- Press CTRL+SHIFT and double-click a cell that you know makes up that
array. After selecting the entire range that contains the array
formula, edit the formula and press CTRL+SHIFT+ENTER if you are using
Microsoft Excel for Windows, or COMMAND+RETURN if you are using
Microsoft Excel for the Macintosh to reenter the array formula.
Article ID: 107905 - Last Review: August 15, 2003 - Revision: 1.1
- Microsoft Excel 97 Standard Edition
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.