Why can’t I delete an array in Excel?
You can’t delete cells in an array formula (you’ll see a “You cannot change part of an array” error), but you can delete the entire formula and start over. You can’t add new cells to a block of result cells, but you can add new data to your worksheet and then expand your formula.
How do you edit an array in Excel?
To edit the contents of an array formula, follow these steps:
- Select a cell in the array range and then activate Edit mode by clicking the formula in the Formula bar or pressing F2.
- Edit the array formula contents.
- Press Ctrl+Shift+Enter to enter your changes.
