Edit an array formula

If an array formula occupies multiple cells, you must edit the entire range as though it is a single cell. You cannot change just one element of an array formula.

1. Select the cell that contains the array formula, or if the array formula occupies multiple cells, select the range that contains the array formula.

   How?

   1. Select a cell within the array.
   2. Press CTRL+/ (forward slash).
2. Press F2.
3. Make changes to the array formula.
4. Press CTRL+SHIFT+ENTER.