Editing an Array Formula in Excel

Procedure

  1. Click the cell in the spreadsheet that contains the array formula.
  2. Click the formula bar at the top of the screen.
  3. Edit the formula that appears in this bar.
    To exit a formula array without editing it, press the Esc key.
  4. Press Ctrl+Shift+Enter.
  5. Select Save from the File menu.