Excel® 2013 Formulas and Functions

2. Using Range Names

In This Chapter

Defining a Range Name

Working with Range Names

Although ranges enable you to work efficiently with large groups of cells, there are some disadvantages to using range coordinates:

• Each time you want to use a range, you must check to see whether it still has the same coordinates (for example, one or more cells might have been inserted or deleted) and, if not, redefine its coordinates.

• Range notation is not intuitive. To know what a formula such as =SUM(E6:E10) is adding, you have to look at the range itself.

• A slight mistake in defining the range coordinates can lead to disastrous results, especially when you’re erasing a range.

You can overcome these problems by using range names, which are labels applied ...