Name Rang in Excel and it's use.

Object of This block:

How We Can Define Name Range in Excel,

How it's Useful to us.

What is Name Range?

Name Range: Giving One Custom Name to One or More than One Cell in Excel.

Ex. A2 = net profit

C1:C10 = productlist

How to Create Name Range:

1. First Select One or More Cell Which of Those, You want to Give a Name.

2. Go to Name box

3. Give a Name to Selected Cell or Cells.

( In this C1:C10 = Productlist )

Space is Not Allowed as Part of a Name.
Names can't look like Cell addresses, Such as A$2 or A2C2
C, c, R, r -- Can't be Used as Names -- Excel Uses Them as Selection Shortcuts
Names are not Case Sensitive. For example, PROUCTLIST and productlist are treated as the same name.

Now, We Understand Use of Name Range:

1. On data validation:

While Creating a drop-down list through Data Validation, There is no need to select Cell range in Source box,

In Source box Just type "=" and "Name of range" (i.e. "=Productlist").

By Typing Name of range in Source box Whole Cell range is Consider as Source.

2. In formula:

While Typing Formula There No Need to Type C1:C10,

Simply Type “productlist” Instead of C1:C10.

(In this "=sum(productlist) Instead of "=sum(C1:C10)" )

3. For Selection of Cell or Cells :
Whenever We Require to Select a Particular Cell range from The Whole worksheet,

We have to Just Type Name of range (i.e. Productlist) in the Name box.

Cell or Cells in that Particular range will select by MS Excel itself.

Blocks of Info