This article is an excerpt from Excel 2007 Formulas by John Walkenbach. Also known as, Mr. Spreadsheet, John is arguably the foremost authority on Excel. His forty-plus books include Excel 2007 Power Programming with VBA, Excel 2007 Charts, and the bestselling Excel 2007 Bible, all published by Wiley. He has also written hundreds of articles and created the award-winning Power Utility Pack. Visit Wiley.com to learn more about this book.
Most intermediate and advanced Excel users are familiar with the concept of named cells or ranges. Naming cells and ranges is an excellent practice and offers several important advantages. As you'll see in this article, Excel supports other types of names — and the power of this concept may surprise you.
