How to define Range Names?
Submitted by Rishie Khurana on Sunday, 30 August 2009No Comment
Excel generally provides more than one ways to perform an action. For defining range names also, it has provided 2 ways:
- Using the Insert –> Name –> Define command in Menu Bar
- Using the Name box (adjacent to formula bar) directly
Here are the steps to define Range names by both the above methods:
Using the Menu Bar:
- Select the cell / range of cells which you would like to name
- Go to Insert –> Name –> Define command
- Now you would see a dialogue box (shown below)
- On the top text area (where the cursor would be blinking by default) type the name that you would like to give to the range selected
- Press Add and then OK
…and you are done!
Using the Name Box:
- Select the cell / range of cells which you would like to name
- Go to Name Box (as shown below)
- Type the name for the range in the Name box and then press Enter
…and you are done!
Leave your response!