How to create an Excel name for a constant In addition to named ranges, Microsoft Excel allows you to define a name without cell reference that will work as a named constantTo create such a name, use either the Excel Define Name feature or Name Manager as explained above For instance, you can make a name like USD_EUR (USD EUR conversion rate) andOn the Formulas tab, in the Defined Names group, click Define NameTo open the Name Manager dialog box, on the Formulas tab, in the Defined Names group, click Name Manager The Name Manager dialog box displays the following information about each name in
Improved Name Manager In Excel For Mac