What are Range Names?

Range Names is another of Excel's feature that makes life of its users a lot easier.

A Range Name, as the name explains itself, is a Name that is given to a cell or a range of cells. This Name then can be used at other locations to refer to the defined range.

Name ranges can be defined in 2 ways:

1. Using the Insert –> Name –> Define command in Menu bar
2. Using the Name box (adjacent to formula bar) directly

Advantages of using Name Ranges:

• Range names are used in soft-coding of big and complex models. Not just complex, range names can also further simplify simpler models
• They make formulas easier to understand and read. They can add meaning to boring formulas by providing them with names
• They are very useful in situtations where VBA coding is used. If a VBA code uses a cell reference and that cell's value need to some other place, the range names can come very handy in such cases

How to define Range Names?

Share on Facebook Share on Twitter Share on Google Plus

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.