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 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. 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. Let us understand the working of conditional formatting by simple Excel examples. Below are the steps to create a name by using the “Define Name” option:What is Name Range in Excel?
Define Names For a Selected Range
Excel names the cells based on the labels in the range you designated.
Update named ranges in the Name Manager (Control + F3)
How to Use
Name Range in Excel?
Example #1 Create a name by using the Define Name option
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).
- In the top left-hand corner of the “Name Manager” dialog window, click the “New… button:”
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.
- The names can start with a letter, backslash (), or an underscore (_).
- The name should be under 255 characters long.
- The names must be continuous and cannot contain spaces and most punctuation characters.
- There must be no conflict with cell references in names using in excelCell reference in excel is referring the other cells to a cell to use its values or properties. For instance, if we have data in cell A2 and want to use that in cell A1, use =A2 in cell A1, and this will copy the A2 value in A1.read more.
- We can use single letters as names, but the letters “r” and “c” are reserved in Excel.
- The names are not case-sensitive – “Tanuj”, “TANUJ”, and “TaNuJ” are all the same in Excel.
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: –
- VBA RangeRange is a property in VBA that helps specify a particular cell, a range of cells, a row, a column, or a three-dimensional range. In the context of the Excel worksheet, the VBA range object includes a single cell or multiple cells spread across various rows and columns.read more
- Data Tables ExcelA data table in excel is a type of what-if analysis tool that allows you to compare variables and see how they impact the result and overall data. It can be found under the data tab in the what-if analysis section.read more
- Data Validation using ExcelThe data validation in excel helps control the kind of input entered by a user in the worksheet.read more
- Paste SpecialPaste special in Excel allows you to paste partial aspects of the data copied. There are several ways to paste special in Excel, including right-clicking on the target cell and selecting paste special, or using a shortcut such as CTRL+ALT+V or ALT+E+S.read more