Edit an array formula

Office Web Components

Show All Show All

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.

    ShowHow?

  2. Press F2.
  3. Make changes to the array formula.
  4. Press CTRL+SHIFT+ENTER.