2. Using 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 ...

Get Excel® 2013 Formulas and Functions now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.