Editing an Array Formula in Excel
Procedure
- Click the cell in the spreadsheet that contains the array formula.
- Click the formula bar at the top of the screen.
- Edit the formula that appears in this bar.To exit a formula array without editing it, press the Esc key.
- Press Ctrl+Shift+Enter.
- Select Save from the File menu.