Step 1 Go to the Defined Names group under Formulas Tab Step 2 Click the arrow button besides Define Name button, and select the Apply Names item from the drop down list Step 3 In the Apply Names dialog box, select the range names that you will apply to formulas, and click OK button Then you will see corresponding cell references in formulas are changed to its defined names Learn more Excel Formulas – fast!I based this video on material found in the Excel Formula 1 ebook, and if you are interested in picking up a copy of this ebook click on this link Bear in mind that I will get a commission from Chandooorg if you purchase a copy of the Formula1 ebook but the only reason I'm promoting it is that I think it can offer good value to Excel users
Can T Replace Table Name In Formula Excel