Names
The trouble with using cell references in formulas is that they're difficult to remember. To make matters worse, cell references can change if cells above or to the left of them are inserted or deleted.
Excel's names feature eliminates both problems by letting you assign easy-to-remember names to individual cells or ranges of cells in your workbooks. The names, which you can use in formulas, don't change, no matter how much worksheet editing you do.
Tips
The Natural Language Formulas feature, which I discuss in Chapter 2, automatically recognizes cell column or row headings as cell names.
Names can be up to 255 characters long and can include letters, numbers, periods, question marks, and underscore characters (_). The first character must ...
Get Microsoft Excel X for Mac OS X: Visual QuickStart Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
