FLASH SALE! - "CHATGPT AND ARTIFICIAL INTELLIGENCE FOR MICROSOFT EXCEL AT 60% OFF" Enroll Now

Name Range in Excel

Updated on December 31, 2023
Article byJeevan A Y
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

What is Name Range in Excel?

The name range in Excel is the range that has been given a name for future reference. To make a range as a named range, select the range of data and then insert a table. Then, we put a name to the range from the Name Box on the left-hand side of the window. After this, we can refer to the range by its name in any formula.

The name range in Excel makes it much cooler to keep track of things, especially when using formulas. You can assign a name to a range. No problem with any change in that range; you need to update the range from the Name Manager in ExcelName Manager In ExcelThe name manager in Excel is used to create, edit, and delete named ranges. For example, we sometimes use names instead of giving cell references. By using the name manager, we can create a new reference, edit it, or delete it.read more. You do not need to update every formula manually. Similarly, you can create a name for a formula. Then, if you want to use that formula in another formula or another location, refer to it by name.

  • The name ranges are significant because you can put any names in your formulas without considering cell references/addresses. Furthermore, you can assign the range with any name.
  • Create a named range for any data or a named constant and use these names in your formulas in place of data references. In this way, you can make your formulas easier to comprehend better. A named range is just a human-understandable name for a range of cells in Excel.
  • Using the name range in Excel, you can simplify and comprehend your formulas better. For example, you can assign a name for a range in an excel sheet for a function, a constant, or table data. Once you start using the names in your Excel sheet, you can easily understand these names.

Define Names For a Selected Range

  • Select the data range you want to assign a name, then select formulas and create from the selection.
Using Name in Excel table 1
  • Click on the “Create Names from Selection,” then select the “Top row,” “Left column,” “Bottom row,” or “Right column” checkbox and select “OK.”
Using Name in Excel table 2

Excel names the cells based on the labels in the range you designated.

  • Use names in formulas, then select a cell and enter a formula.
  • Place the cursor where you want to use the name range formula.
  • Type the first letter of the name, and select the name from the list that appears.
  • Or, select “Formulas,” then use in formula and select the name you want to use.
  • Press the “Enter” key.

–>> If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

Update named ranges in the Name Manager (Control + F3)

You can update the name from the Name Manager. Press “Ctrl” and “F3” to update the name. Select the name you want to change, then change the reference range directly.

How to Use Name Range in Excel?

Let us understand the working of conditional formatting by simple Excel examples.

You can download this Using Names in Excel Template here – Using Names in Excel Template

Example #1 Create a name by using the Define Name option

Below are the steps to create a name by using the “Define Name” option:

  1. First, select the cell(s).


    Using Name in Excel example 1

  2. On the “Formulas” tab, click the “Define Name” in the “Defined Names” group.


    Using Name in Excel example 1-1

  3. In the “New Name” dialog box, specify three things:


    Using Name in Excel example 1-2

  4. First, in the “Name” box, type the range name.


    Using Name in Excel example 1-3

  5. In the “Scope” drop-down, set the name scope (Workbook by default).


    Using Name in Excel example 1-4

  6. In the “Refers to” box, check the reference and correct it if needed. Finally, click “OK” to save the changes and close the dialog box.


    Using Name in Excel example 1-5

Example #2 Make a named range by using Excel Name Manager

  • Go to the “Formulas” tab, then the “Defined Names” group, and click the “Name Manager” or press “Ctrl + F3” (the preferred way).
example 2
  • In the top left-hand corner of the “Name Manager” dialog window, click the “New… button:”
example 2-1

Name Range using VBA.

We can apply the naming in VBA; here is the example as follows:

Sub sbNameRange()

‘Adding a Name

Names.Add Name:=”myData”, RefersTo:=”=Sheet1!$A$1:$A$10″

‘OR

‘You can use Name property of a Range.

Sheet1.Range(“$A$1:$A$10”).Name = “myData”

End Sub

Things to Remember

We must follow the below instruction while using the name range.

Recommended Articles

This article is a guide to the Name Range in Excel. We discuss using names in Excel, practical examples, and downloadable Excel templates here. You also may look at these useful functions in Excel: –