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:
  1. Using the Insert –> Name –> Define command in Menu Bar
  2. 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:
  1. Select the cell / range of cells which you would like to name
  2. Go to Insert –> Name –> Define command
  3. Now you would see a dialogue box (shown below)
  4. 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
  5. Press Add and then OK
...and you are done!




Using the Name Box:
  1. Select the cell / range of cells which you would like to name
  2. Go to Name Box (as shown below)
  3. 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.
Share on Google Plus

About Nifty Guru

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.
    Blogger Comment
    Facebook Comment

0 comments:

Post a Comment

Monday, August 31, 2009

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:
  1. Using the Insert –> Name –> Define command in Menu Bar
  2. 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:
  1. Select the cell / range of cells which you would like to name
  2. Go to Insert –> Name –> Define command
  3. Now you would see a dialogue box (shown below)
  4. 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
  5. Press Add and then OK
...and you are done!




Using the Name Box:
  1. Select the cell / range of cells which you would like to name
  2. Go to Name Box (as shown below)
  3. 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.

How to define Range Names?SocialTwist Tell-a-Friend

0 comments:

Post a Comment