Blocks of Info

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 ) The following Characters are not allowed as Name: 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  dr...