How to define Range Names?

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!

Now you have learned the usage of and the steps to define range names. But, there are some important points that one should keep in mind while defining the range names.

About Dhakkanz

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.

Monday, August 31, 2009