How Do You Apply A Defined Name To An Existing Formula?
How Do You Apply A Defined Name To An Existing Formula? Select one or more formula cells that you want to update. Go to the Formulas tab > Define Names group, and click Define Name > Apply Names… In the Apply Names dialog box, click on the names you want applied, and then click OK.