If you click on the named range then cell B2 will be selected.ģ. If you click on the Name Box drop-down arrow, you will see the named range.Ĥ. Using the Name Box, type Age and press Enter.ģ. In the example below, we have cell B2, that will contain the age of the user.Ģ. You can create named ranges in Excel by using the Name Box. Create A Named Range By Using The Name Box If you’d like to learn about the differences between absolute, relative and mixed references, read this post.Ģ. By default, Excel creates an absolute reference. In the Refers to: section check that the range of interest is selected.

You can add a comment to provide more information about the range. If the scope is set to worksheet, then the name will only be recognised in the worksheet. In this case we will leave the default option. The default setting is the workbook which means that you can use the named range anywhere in the workbook. The Scope refers to where the named range can be applied. Type the name which you’d like your range to be. With the range selected, go to the Formulas Tab on the ribbon (Step 1 in the image) and on the Defined Names group, choose Define Name (Step 2 in the image). Select the cell range B1:B5, which contains the data.Ģ. In the example below, we have a data range in Excel that shows common beverages.ġ. Tip: Try to give your range a name that describes the data it contains.įour Different Ways To Create A Named Rangeġ. You can use symbols such as forward slashes, underscores and dots in names, but you cannot use other symbols. For example, you cannot call your named range “A7”. You cannot use actual cell addresses as named ranges. The first letter can only be a letter, an underscore, or a backslash. Navigation to your named range is much easier through the Name Box feature.Ī name cannot be more than 255 characters long. Named ranges can be managed easily by using Name Manager. You don’t have to remember the cell reference. You don’t have to physically select the cell range each time you want to use it. The advantages of using named ranges include: Working with named ranges, is covered extensively in our intermediate and advanced Excel courses. You can use an Excel named range in a formula, to create a drop-down list, or in your conditional formatting. A named range is a descriptive name given to a single cell or range of cells.

How do you find a range in excel