Defining a Range Name in Microsoft Excel 2010

In this article, we will learn how we can define a range name in Microsoft Excel 2010. There are two techniques to define a range name.

Let’s take an example to understand how we can define a range name in Microsoft Excel.

We have month name list in column. Now, we want to define the name.
 
img1
 
First technique to define the range name

Follow below given steps:-

  • Select the range A1:A13.
  • In the Name box, write the Month_Name, and then press Enter on your keyboard.

 
img2
 
Second technique to define the range name

  • Select the range A1:A13.
  • Press the key Ctrl+F3 or Go to Formulas tab, and click on Name Manager from the Defined Names groups.

 
img3
 

  • Name manager dialog box will appear, and then click on New.
  • “New Name” dialog box will appear.

 
img4
 

  • Write the range name Month_Name.
  • In Refers to, select the range A1:A13.
  • Click on OK.

 
img5
 
This is all about we can define a range name in Microsoft Excel.
 
 

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube