Excel Guides

Understanding Names in Excel

When it comes to working with data in Excel, one of the first things you need to understand is how to work with names. Names are used to identify cells, ranges, formulas, and other objects in Excel. They can make working with data much easier and can help you keep track of what's going on in your workbook. In this article, we'll take a look at how to use names in Excel and how they can be helpful.

Creating Names in Excel

There are a few different ways that you can create names in Excel. The first way is to simply select a cell or range of cells and then type a name into the Name Box, which is located to the left of the formula bar:

You can also create names by using the Name Manager. To access the Name Manager, go to the Formulas tab and click on Name Manager:

This will open up the Name Manager dialog box. From here, you can see all of the names that have been created in the workbook as well as create new names. To create a new name, click on New:

This will open up the Create Name dialog box. Here, you can specify the name and what it refers to. You can also give it a description if you want:

Using Names in Excel

Once you have created some names, you can start using them in your formulas.

Tip: If you start typing a name into a formula, Excel will automatically suggest matching names for you.
Note: If you want to use a name that has spaces in it, you need to enclose it in square brackets [ ]. For example, if you have a name called "Total Sales", you would use [Total Sales] in your formulas.

Referring to Cells by Name

One of the most common ways that people use names is by referring to cells by their name instead of their cell address.

[cell_name] =A1  
[cell_name] =$A$1  
[cell_name] =A$1  
[cell_name] =$A1  

Referring to Ranges by Name

Another common way that people use names is by referring to ranges by their name instead of their cell address.

[range_name]:[range_name]  

Defining Names for Formulas

"+ "

"+ ""+ "You can also define names for entire formulas."+ ""+ "

"+ "
    "+ "
  • "+ ""+ "To do this:"+ ""+ "
      "+ "
    1. "+ "Type the formula into a cell."+ "
    2. "+ "
    3. "+ "Select the cell that contains the formula."+ "
    4. "+ "
    5. "+ "Go to the Formulas tab and click Define Name."+ "
    6. "+ "
    "+ +"\n" + "\n" + "\n" + "\n" + "\n" + "\n" + "\n" + "\n" + "\n" + "\n" + "\n" + "\n";

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.