Hi what is the purpose of define name in Excel 2003

Thank you
Who is Participating?
Shanan212Connect With a Mentor Commented:
Define name is used to 'group cells' together as a single 'table' so that its easier to use in formulas.


using define name feature, (say you have a sheet name called 'THISISASAMPLESHEET' and) you can select range 'A1:B20' and type in name as 'sample'

then you can use it on a vlookup as such


instead of

Martin LissConnect With a Mentor Older than dirtCommented:
Do you mean a named range? If so you can assign a name to a range of cells that contains values and then for example have those values show up in a dropdown for data entry purposes.
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
Define > Name

enables you to assign a name to a range which you can easily remember and refer to instead of remembering the range address. Furthermore if the range address changes due to inserting or deleting rows or moving cells you still can refer to the name you have assigned.
TracyVBA DeveloperCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.