assign name manager in Excel

Q2. Can I assign a NAME to a constant (similar to declaring constants in coding environment like VBA)?

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 excel assign name manager


You can find similar Excel Questions and Answer hereunder

1) How can I get row count of filtered data?

2) I have a complex WorkSheet with lot of fields and data - How can I quickly find the cells that have formulas?

3) How do I get the principal part of loan payment for a period given Loan amount, Rate of Interest and period?

4) How can I extract file name from a full path including folder path and file name?

5) How do I calculate monthly payment given Loan amount, Rate of Interest and period?

6) How do I restrict user entry in ActiveX Text Box to just numeric values?

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

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 loop through all WorkSheets and get their names using VBA?

10) Applying a countif formula only to visible cells in a filtered list in Excel

11) Is there a way I can round the sales figure to the nearest 500?

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

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

14) I have a table where inputs have to come from various users. In Excel, how can I highlight a row automatically that does not have input so that I can follow up with the concerned?

15) I have read that Merging cells should be avoided if possible. In Excel, how can I then make my Title appear in the center of my Data Table?