To edit an array formula in Excel, click on the cell containing an array formula and then select the formula bar present at the top. You can now modify the formula as per your requirements.