MS Excel for Range Names

A name can be given to a single cell or a range of cells ( e.g.B3:F9). The range name can be used in place Of these cell references .Also the range specified for a range name can be modified.

To define a name ,following points have to be considered .

1. Name contain only letters from A-Z., or a-z, numbers 1-9.

    The period ( .) and the underscore ( _ ) .

2. Maximum length can be up to 255 characters .

3. Name cannot be same as cell reference like $F10$ or F10 .

4. Spaces are not allowed .

Valid Range Names                                                                         Invalid Range Names 

Months                                                                                                First Name 

Final_ year                                                                                          5 Days

Date _ of _ join                                                                                    R5C12

Basic _ salary 

Year 5 

Ways to create name 

Using Name Box

1. Select the range of cells.

2. Click on Name Box on Formula bar and type the name .

You'll be warned if the same name is given which has already been defined .

Using Define Name Dialogue Box

1. Select the range of cells.

2. Choose Insert -> Name  -> Define .

Specify the Range Name in this text box.