Legacy Ctrl+Shift+Enter (CSE) array formulas have specific rules for editing individual cells or the array range. If you're using a dynamic array formula, you can edit the formula in the cell where it was entered, and the results spill automatically into neighboring cells.
If you can't change an individual cell in a legacy array formula, use the following guidance to edit the formula:
If you've entered a single-cell legacy array formula, see Create an array formula that calculates a single result in Create an array formula in Excel, select the cell, press F2, make your changes, and then press Ctrl+Shift+Enter.
If you've entered a multi-cell legacy array formula, see Create an array formula that calculates multiple results in Create an array formula in Excel, select all the cells that contain it, press F2, and follow these rules:
- You can't move the individual cells that contain your formula, but you can move all of them as a group, and the cell references in the formula will change with them. To move them, select all the cells, press Ctrl+X, select the new location and press Ctrl+V.
- 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 or remove the formula in Excel and start over, see Create an array formula in Excel.
- 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. For more inforation, see Guidelines and examples of array formulas.
- After you make your changes, press Ctrl+Shift+Enter.
You can also use array constants, which are parts of an array formula that you enter in the formula bar. Array constants have additional editing and usage rules. For more information, see Use array constants in array formulas.