Assign name manager in Excel

For example, I want to define Target Sales as $12,000 for the year 2016 in an Excel workbook and use it for all calculations in Workbook.

To do it in Excel, here is the answer:

a) To assign a constant to a NAME, click on "Name Manager" under "Formulas". In the "New Name" dialog box that appears, enter the name that you would like to assign to constant ("TARGET" in this case).

In the "Refers To" field, enter "12000".

excel assign name manager

b) The NAME can then be used in formulas to refer to the constant value as shown below.

excel assign name manager


You can find similar Excel Questions and Answer hereunder

1) The scenario manager in Excel VBA allows to explore various scenarios in a very easy way

2) How can I convert Column numbers into Column names for use in range definition?

3) How can I extract First Name and Last Name from a cell that has Full name?

4) How can I loop through all WorkSheets and get their names using VBA?

5) How to use the scenario manager in Excel

6) The name manager in Excel is very useful to keep an overview and manage all the variable names in Excel. Here how to use the name manager in VBA

7) How to use the name manager in Excel to have a good overview of the various variables and their names in Excel

8) How can I set up a dynamic named range that expands automatically when new items are added to the list?

9) How can I display list of NAMES in a worksheet?

10) How do I assign a macro to a shape using VBA?


Here the previous and next chapter