Cloud Training (Online)




Named Range in Microsoft Excel

This article will tell you about the feature called Named Range in Microsoft Excel and how to implement it.

What is Named Range?

Named Range in Microsoft Excel is a feature that lets you name a cell or a range of cells to make you work easily when you use formulas or some other operation.

How to create a Named Range in Excel?

To create a named range do the following steps.


First right click and then drag the cursor over the range of the cells that you want to name.

After selecting the range of cells go to the Formulas Menu in the Menu bar.

How to create a Named Range in Excel?

Select Define Name under the Defined Names group.

Named Range in Microsoft Excel

Type the Name you wish to have in the Name field of the New Name dialog box that opens up.

Named Range in Microsoft Excel

After finalizing the name of the range of the cells click on OK to proceed.


Named Range in Microsoft Excel

NOTE: Microsoft has few rules to name the range of cells.

Named Range in Microsoft Excel

Another way to name a range of cells is by using the Name Box that is beside the formula bar.

Named Range in Microsoft Excel

You can directly type the name in the box.

Named Range in Microsoft Excel

Make sure you follow the restrictions of naming by Microsoft.


We still have another way to name i.e, by selecting the Create from Selection option in the “Defined Names” group which can be found in the Formulas Bar of the Menu Bar.

Named Range in Microsoft Excel

Then choose your option in Create Names from Selection dialog box that opens up.

Named Range in Microsoft Excel

Click on OK to proceed.

This is how you name a range of cells.

Similarly to name a cell do the same steps mentioned above expect that select only the cell you want to name.