Names can be used to name MS Excel objects like cells, cell ranges, tables, formulas, constants, etc. These can then be referenced in any other object. Let us further our understanding with the help of an example. I need to calculate the simple interest for the following data. I have given names to the cells B1, B2, and B3. So when I write the formula for SI, I can simply use the names rather than the cell references.
How to Create Names
How to Create Names
How to Use Names
How to Use Names
It’s simple – whenever you want to use a name in a formula, start typing and you will see it appear in the suggestion list for you to select. Otherwise navigate to Formulas -> Defined Names and select the required name from Use in Formula dropdown.
How to Manage Names
How to Manage Names
You must also have the option to edit and delete names in case you want to change few definitions or get rid of them entirely. That’s where the Name Manager comes into picture. It also shows you details of values, cell and sheet references, and the scope of the name. Cool Tip: When you create tables on a worksheet they are assigned names automatically. The automatic names will be Table1, Table2 and so on. However, you may change the names from the Name Manager window.
Conclusion
These are the basics of implementing and managing names that any Excel user should know. Once you get used to names, you can create and use formulas with ease. It may take some time to learn and get into this habit, but I suggest you put in the effort. It’s well worth it! Image Credit: Carole Carey The above article may contain affiliate links which help support Guiding Tech. However, it does not affect our editorial integrity. The content remains unbiased and authentic.
