Edit an array formula

Microsoft Office Excel 2003

Show All Show All

Edit an array formula

  1. Click the cell that contains the array formula.
  2. Click in the formula bar 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.