How to name the range of cells in Excel

How to create a Named Range in ExcelErlinda Scarlet2 years agoDid you know you can name cells based on your preference? Did you know you can set meaningful names as your formulas?

How to name the range of cells in Excel

How to create a Named Range in ExcelErlinda Scarlet2 years ago

Did you know you can name cells based on your preference? Did you know you can set meaningful names as your formulas? Do you want your formulas to be all the more descriptive? Well, then you are looking at the right article. Heres everything you will know about how to create a Named Range. So, Lets get started.

Named Range  A Glance

A named range shows a descriptive name for a cell or a range of cells in a worksheet. It is an easy and speedy process to create a named range. It serves as a huge time saver and is efficient to use. Instead of using the cell reference, you can simply use the name allocated to the cells.

How to Create Name Range in MS Excel | Step by Step Process | 2020

Lets take a look at some examples to create a named range.

Example: 1

Step 1: Select the cell range, in this example I will be creating a named range for cell C5: C13.

Step 2: An easy way to create a named range is by selecting and cells and naming them in the Name box. Alternatively, you can also press Alt+F3.

Step 3: In this example, I have named the cells as Revenue_2016 in the name box.

create a named range

Step 4: Hit Enter, you can now see the name of the cell in the drop down of the name box.

create a named range

Step 5: As you can see from the below image, the cell name has been added in the formula list and therefore you can directly apply it by pressing the tab key or by double-clicking.

How to create a Named Range in Excel 1

From the below image you can see the result.

How to create a Named Range in Excel 2

Example: 2

You can also create a name range using the name manager option.

Step 1: Go to the Formulas tab >> select Name manager. Alternatively, you can use the shortcut key Ctrl+F3.

How to create a Named Range in Excel 3

Step 2: The New Manager dialog box appears. Since we are going to create a new name select the New tab.

How to create a Named Range in Excel 4

Step 3: A New Name dialog box appears.

How to create a Named Range in Excel 5

Step 4: Enter the name you want to set in the Name box, if you want the name to be available in your entire workbook select the workbook in the scope box, to show the name in a single worksheet select the sheet name. Click Ok.

How to create a Named Range in Excel 6

Step 5: You can see that the name range is given in the formula list.

How to create a Named Range in Excel 7

From the below image you can see the result.

How to create a Named Range in Excel 8

These are two ways in which you can create a named range easily and efficiently.

Points to remember:

  • Names cannot contain spaces or any special characters, instead, they can be replaced by an underscore (_), dot (.), and backslash (\).
  • Names cannot begin with numbers.
  • Names cannot coincide with the cell references (Eg. A1 or M100)
  • Names are not case sensitive.

To read more related articles click here.
To have a clear vision on Named ranges in Excel  Click here

To have Hands on experience download the working file attached below.

Practice FilesDownloadCategories: FormulasTags: create a named range, Name Manager, Named Ranges in ExcelLeave a Comment

Video liên quan