Show All

Edit an array formula

1. Click the cell that contains the array formula.
2. Click in the formula bar . When the formula bar is active, the braces ( { } ) do not appear in the array formula.
3. Edit the array formula.
4. Press CTRL+SHIFT+ENTER.