How can I change part of an array in Excel? 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.